SqlOperationTypeEnum Enumeration

Kentico 9.0 API Reference

Kentico 9.0 API Reference

AbstractDataConnection Class

AbstractDataProvider Class

AbstractInfo(TInfo) Class

AbstractInfoBase(TInfo) Class

AbstractInfoBase(TInfo).GeneralizedInfoWrapper Class

AbstractInfoProvider(TProvider) Class

AbstractInfoProvider(TInfo, TProvider) Class

AbstractInfoProvider(TInfo, TProvider, TQuery) Class

AbstractProvider Class

AbstractProvider.OnLoadProvider Delegate

AbstractProvider(TProvider) Class

AbstractProviderDictionary Class

AbstractQueryObject Class

AbstractSqlGenerator Class

AbstractTableManager Class

AdvancedConnectionSettings Class

AggregatedColumn Class

AggregationType Enumeration

AsyncAction Delegate

AsyncProcessData Class

AsyncWorker Class

AsyncWorkerStatusEnum Enumeration

AuthorizationResultEnum Enumeration

BaseAbstractInfoProvider Class

BaseCollectionSettings Class

BaseInfo.GeneralizedInfoWrapper Class

BaseInfo.PermissionObjectType Enumeration

BindingCollection Class

BindingRepository Class

BulkInsertSettings Class

BulkUpdateEventArgs Class

BulkUpdateHandler Class

ClassCodeGenerationSettings Class

ClassSiteInfo Class

ClassSiteInfoProvider Class

ClassStructureInfo Class

CloneResult Class

CloneSettings Class

CloneSettings.OnCloneInsert Delegate

CMSApplication Class

CMSConnectionContext Class

CMSConnectionScope Class

CMSHttpApplication Class

CMSLateBoundTransaction Class

CMSOutputMetaFile Class

CMSTransactionScope Class

CodeNameNotUniqueException Class

CodeNameNotValidException Class

CollectionPropertyTransformation(ResultType) Class

CollectionPropertyWrapper Class

CollectionPropertyWrapper(ObjectType) Class

ColumnDefinition Structure

ColumnsTranslationEventArgs Class

ColumnsTranslationEvents Class

ColumnsTranslationHandler Class

CombinedInfoObjectCollection Class

CombinedInfoObjectCollection(CollectionType, ObjectType) Class

CompareSettings Class

ConnectionContext Class

ConnectionHelper Class

ContinuousIntegrationSettings Class

CountColumn Class

CustomProviderAttribute Class

DatabaseFieldAttribute Class

DatabaseHelper Class

DatabaseIDFieldAttribute Class

DatabaseMappingAttribute Class

DatabasePermission Class

DatabaseSeparationHelper Class

DataClassFactory Class

DataClassInfo Class

DataClassInfoBase(TInfo) Class

DataClassInfoProvider Class

DataClassInfoProviderBase(TProvider) Class

DataClassNotFoundException Class

DataConnectionFactory Class

DataConnectionFactory.GetConnectionEventHandler Delegate

DataDefinition Class

DataDefinitionItemEventArgs Class

DataDefinitionItemEvents Class

DataDefinitionItemHandler Class

DataDefinitionItemChangeEventArgs Class

DataDefinitionItemChangeHandler Class

DataEngineCodeTemplateGenerator Class

DataEngineModule Class

DataEngineModuleMetadata Class

DataExtensions Class

DataParameter Class

DataQuery Class

DataQueryBase(TQuery) Class

DataQuerySettings Class

DataQuerySettingsBase(TQuery) Class

DataQuerySource Class

DataQuerySourceParameters Class

DataSetPostProcessingEventArgs Class

DataTaskType Class

DataType(T) Class

DataTypeManager Class

DefaultClassThumbnail Class

DefaultDataSettings Class

DeletedFKs Class

DynamicDataParameter Class

DynamicObjectTypeInfo Class

EmptyCollection(InfoType) Class

EnumerableWrapper(TObject) Class

EnumerationObjectTypeFilter Class

ExecuteQueryEventArgs(TResult) Class

ExecuteQueryHandler(TResult) Class

ExportFormatEnum Enumeration

ExportObjectSettings Class

ExpressionBuilderSettings Class

ExternalColumnSettings(InfoType) Class

ExtraColumn Class

FeatureEnum Enumeration

FieldBase(FieldType) Class

FieldDataType Class

FieldInfo Class

FilteredInfoObjectCollection Class

FullNameInfoObjectCollection Class

GeneralConnection Class

GeneralInfo Class

GeneralInfoProvider Class

GeneralizedAbstractInfo Class

GeneralizedAbstractInfo(TInfo) Class

GeneralizedInfo Class

GetIDParameters Class

GetObjectsDataSettings Class

HashtableSettings Class

HierarchyHelper Class

CheckDependenciesException Class

ICMSQueryable Interface

ICMSQueryable(TObject) Interface

IDataClass Interface

IDataConnection Interface

IDataDefinitionItem Interface

IDataProvider Interface

IDataQuery Interface

IDataQuery(TQuery) Interface

IDataQuerySettings Interface

IDataQuerySettings(TQuery) Interface

IDNotTranslatedException Class

IDQuery(ObjectType) Class

IFakeMethods Interface

IField Interface

IInfo Interface

IInfoDataSet Interface

IInfoFake(TInfo) Interface

IInfoObjectCollection Interface

IInfoObjectCollection(TInfo) Interface

IInfoObjectRepository(TCollection) Interface

IInfoProviderFake(TInfo, TProvider) Interface

ILicenseService Interface

ImportExportSettings Class

IMultiObjectQuery Interface

IMultiObjectQuery(TQuery, TInnerQuery, TObject) Interface

IMultiQuery Interface

IMultiQuery(TQuery, TInnerQuery) Interface

IncludeToParentEnum Enumeration

InfoCollectionSettings Class

InfoDataSet(TInfo) Class

InfoFakeSettings Class

InfoHelper Class

InfoIdentifier Class

InfoObjectCollection Class

InfoObjectCollection(TInfo) Class

InfoObjectException Class

InfoObjectFactory Class

InfoObjectRepository Class

InfoObjectRepository.OnNewCollectionHandler Delegate

InfoObjectRepository(TCollection, TObject, TSettings) Class

InfoObjectRepository(TCollection, TObject, TSettings).LoadCollectionHandler Delegate

IObjectQuery Interface

IObjectQuery(TQuery, TObject) Interface

IObjectTypeDriven Interface

IObjectTypeFilter Interface

IProviderDictionary Interface

IProviderDictionaryTemplate(ValueType) Interface

IQueryColumn Interface

IQueryExpression Interface

IQueryObject Interface

IQueryObjectWithValue Interface

IQueryParameters Interface

IQuerySource Interface

ISearchable Interface

ISearchDocument Interface

ISearchField Interface

ISearchFields Interface

ISearchIndexInfo Interface

ISqlGenerator Interface

ISqlServerCapabilities Interface

IStringMetadata Interface

IStructuredData Interface

IStructuredField Interface

ITableManager Interface

ITransactionScope Interface

IWhereCondition Interface

IWhereCondition(TParent) Interface

JoinTypeEnum Enumeration

LayoutHelper Class

LayoutTypeEnum Enumeration

LicenseException Class

LinqSqlMethods Class

LoadDataEventHandler Delegate

LoadDataSettings Class

LoadHashtableEnum Enumeration

LoadProviderEventArgs Class

LogObjectChangeEventArgs Class

LogObjectChangeHandler Class

LogObjectChangeSettings Class

MemoryDataQuerySource Class

MessageTypeEnum Enumeration

MetaFileInfo Class

MetaFileInfoProvider Class

MetaFileURLProvider Class

MissingSQLTypeException Class

ModuleCommands Class

ModuleManager Class

MultiObjectQuery Class

MultiObjectQueryBase(TQuery, TInnerQuery, TObject) Class

MultiQueryBase(TQuery, TInnerQuery) Class

NestedQuerySettings Class

NestedSelectQueryColumn Class

NotImplementedInfo Class

ObjectActionEnum Enumeration

ObjectAttachmentsCategories Class

ObjectDataEventArgs Class

ObjectDataEventHandler Class

ObjectDependency Class

ObjectDependencyEnum Enumeration

ObjectEventArgs Class

ObjectEventArgs(TObject) Class

ObjectEvents Class

ObjectHandler Class

ObjectHelper Class

ObjectChangeOrderEventArgs Class

ObjectChangeOrderEventArgs(TObject) Class

ObjectChangeOrderHandler Class

ObjectPriorityEnum Enumeration

ObjectProperty Class

ObjectQuery Class

ObjectQuery(TObject) Class

ObjectQueryBase(TQuery, TObject) Class

ObjectQuerySettings Class

ObjectRangeEnum Enumeration

ObjectRelationshipsCollection Class

ObjectSecurityEventArgs Class

ObjectSecurityEventArgs(TObject) Class

ObjectSecurityHandler Class

ObjectSettingsInfo Class

ObjectSettingsInfoProvider Class

ObjectSortEventArgs Class

ObjectSortEventArgs(TObject) Class

ObjectSortHandler Class

ObjectSource(TObject) Class

ObjectSourceBase(TSource) Class

ObjectStatusEnum Enumeration

ObjectTreeLocation Class

ObjectTypeColumnNotFoundException Class

ObjectTypeInfo Class

ObjectTypeInfo.ObjectLoadRelatedDataEventHandler Delegate

ObjectTypeInfo.OnGetContentEventHandler Delegate

ObjectTypeInfo.OnLogObjectChangeEventHandler Delegate

ObjectTypeListItem Class

ObjectTypeManager Class

ObjectTypeSequenceAnalyzer Class

ObjectTypeTreeNode Class

ObjectTypeTreeNode.OnBeforeCreateNodeHandler Delegate

OperationTypeEnum Enumeration

OrderByColumn Class

OrderByColumnList Class

OrderDirection Enumeration

OtherBindingCollection Class

OtherBindingRepository Class

PermissionCheckException Class

PermissionsEnum Enumeration

PredefinedObjectType Class

ProviderDictionary(TKey, TValue) Class

ProviderDictionaryCollection Class

ProviderDictionaryCollection.LoadGenerationEventHandler Delegate

ProviderDictionaryCollection.LoadGenerationParamsEventHandler Delegate

ProviderGuidDictionary Class

ProviderHelper Class

ProviderInfoDictionary(KeyType) Class

ProviderIntDictionary Class

ProviderStringDictionary Class

ProviderStringValueDictionary Class

ProviderStringValueDictionary(T) Class

QueryColumn Class

QueryColumnBase(TColumn) Class

QueryColumnList Class

QueryColumnListBase Class

QueryColumnSqlFunctions Class

QueryColumnXmlExtensions Class

QueryDataParameters Class

QueryExecutionTypeEnum Enumeration

QueryExpression Class

QueryExpressionBase(TExpression) Class

QueryInfo Class

QueryInfoBase(TInfo) Class

QueryInfoProvider Class

QueryInfoProviderBase(TProvider) Class

QueryListInfo Class

QueryMacros Class

QueryName Class

QueryOperator Enumeration

QueryParameters Class

QueryParametersBase(TParent) Class

QuerySource Class

QuerySourceBase(TSource) Class

QuerySourceTable Class

QueryTypeEnum Enumeration

QueryUnaryOperator Enumeration

QueryValueExpression Class

RowNumberColumn Class

SearchAnalyzerTypeEnum Enumeration

SearchFieldsConstants Class

SearchFieldsExtensions Class

SearchIndexSettings Class

SearchIndexSettingsInfo Class

SearchSettings Class

SearchSettingsInfo Class

SelectCondition Class

SelectConditionList Class

SelectQueryColumnBase(TColumn) Class

SeparatedField Class

SeparatedTables Class

SerializationSettings Class

SettingsCategoryContainer Class

SettingsCategoryInfo Class

SettingsCategoryInfoProvider Class

SettingsKeyActionEnum Enumeration

SettingsKeyChangedEventArgs Class

SettingsKeyInfo Class

SettingsKeyInfoProvider Class

SettingsKeyName Class

SettingsService Class

SimpleObjectHandler Class

SiteInfoIdentifier Class

SpecialFunctions Class

SQLEngineEditionEnum Enumeration

SqlEvents Class

SqlGenerator Class

SqlHelper Class

SqlInstallationHelper Class

SqlInstallationHelper.LogMessage Delegate

SqlInstallationHelper.LogProgress Delegate

SqlOperationTypeEnum Enumeration

SqlOperator Class

SqlRepresentationAttribute Class

SQLScript Class

SqlSecurityHelper Class

SQLServerAuthenticationModeEnum Enumeration

SqlServerCapabilitiesFactory Class

SQLSettings Class

StructuredField Class

StructuredField(TImplementationType) Class

SynchronizationSettings Class

SynchronizationTypeEnum Enumeration

SystemColumns Class

SystemViewNames Class

TableManager Class

TaskTypeEnum Enumeration

TempFileInfo Class

TempFileInfoProvider Class

TranslationHelper Class

TranslationParameters Class

TranslationReferenceLoader Class

TraverseObjectSettings Class

TraverseObjectSettings.OnItem Delegate

TraverseObjectSettings.OnProcessArraySeparator Delegate

TraverseObjectSettings.OnProcessEndCollection Delegate

TraverseObjectSettings.OnProcessID Delegate

TraverseObjectSettings.OnProcessObject Delegate

TraverseObjectSettings.OnProcessStartCollection Delegate

TypeCondition Class

TypeEnum Enumeration

TypeInfoEvents Class

UpdateQueryExpression Class

UpdateResultEnum Enumeration

UseDefaultQueryEnum Enumeration

WhereBuilder Class

WhereCondition Class

WhereConditionBase(TParent) Class

WorkflowStepTypeEnum Enumeration

Click or drag to resize

SqlOperationTypeEnum Enumeration

Enumeration of the SQL operations.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0

Syntax

C#

public enum SqlOperationTypeEnum

Members

	Member name	Value	Description
	UnknownQuery	0	Uknown query.
	SelectQuery	1	Selection query.
	InsertQuery	2	Insertion query.
	UpdateQuery	3	Update query.
	DeleteQuery	4	Delete query.
	SelectAll	7	Selection all query.
	DeleteAll	10	Deletion all query.
	SelectModifiedFrom	11	Selection query from specified date of modification.
	InsertWithIdentity	14	Insert record with the identity column.
	UpdateAll	15	Updates multiple items based on the columns and where condition.
	GeneralSelect	16	General select query
	GeneralInsert	17	General insert query
	GeneralUpdate	18	General update query
	GeneralDelete	19	General delete query
	GeneralUpsert	20	General upsert (insert/update) query

See Also

Reference

CMS.DataEngine Namespace

Copyright (c) 2015 Kentico Software

Send comments on this topic to support@kentico.com