SqlOperationTypeEnum Enumeration

Kentico 11 API Reference

Kentico 11 API Reference

CMS.DataEngine Namespaces

AbstractDataConnection Class

AbstractDataProvider Class

AbstractInfo(TInfo) Class

AbstractInfoBase(TInfo) Class

AbstractInfoBase(TInfo).GeneralizedInfoWrapper Class

AbstractInfoProvider Class

AbstractInfoProvider(TInfo, TProvider) Class

AbstractInfoProvider(TInfo, TProvider, TQuery) Class

AbstractProviderDictionary Class

AbstractQueryObject Class

AbstractSqlGenerator Class

AbstractSynchronizationSettings Class

AbstractTableManager Class

AggregatedColumn Class

AggregationType Enumeration

ApplicationInitException Class

AsyncAction Delegate

AsyncProcessData Class

AsyncWorker Class

AsyncWorkerStatusEnum Enumeration

AuthorizationResultEnum Enumeration

BaseCollectionSettings Class

BaseInfo.GeneralizedInfoWrapper Class

BaseInfo.PermissionObjectType Enumeration

BindingCollection Class

BindingRepository Class

BulkDeleteEventArgs Class

BulkDeleteHandler Class

BulkDeleteSettings Class

BulkInsertDataEventArgs Class

BulkInsertDataHandler Class

BulkInsertEventArgs Class

BulkInsertHandler Class

BulkInsertSettings Class

BulkUpdateEventArgs Class

BulkUpdateHandler Class

CheckDependenciesException 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

ConnectionContext Class

ConnectionHelper Class

ContinuousIntegrationSettings Class

CountColumn Class

CreateSearchFieldEventArgs Class

CreateSearchFieldFromSettingsEventArgs Class

CreateSearchFieldFromSettingsHandler Class

CreateSearchFieldHandler Class

CreateSearchFieldOption Enumeration

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

DataDefinitionItemChangeEventArgs Class

DataDefinitionItemChangeHandler Class

DataDefinitionItemEventArgs Class

DataDefinitionItemEvents Class

DataDefinitionItemHandler 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

ExpressionBuilderSettings Class

ExternalColumnSettings(InfoType) Class

ExtraColumn Class

FeatureEnum Enumeration

FieldBase(FieldType) Class

FieldDataType Class

FieldInfo Class

FullNameInfoObjectCollection(TInfo) Class

GeneralConnection Class

GeneralInfo Class

GeneralInfoProvider Class

GeneralizedAbstractInfo Class

GeneralizedAbstractInfo(TInfo) Class

GeneralizedInfo Class

GetIDParameters Class

GetObjectsDataSettings Class

HashtableSettings Class

HierarchyHelper Class

IBulkOperationProvider Interface

ICMSQueryable Interface

ICMSQueryable(TObject) Interface

IDataClass Interface

IDataConnection Interface

IDataContractSerializerService(T) Interface

IDataDefinitionItem Interface

IDataProvider Interface

IDataQuery Interface

IDataQuery(TQuery) Interface

IDataQuerySettings Interface

IDataQuerySettings(TQuery) Interface

IDNotTranslatedException Class

IDQuery(ObjectType) Class

IField Interface

IFullNameInfoProvider Interface

IInfo Interface

IInfoDataSet Interface

IInfoObjectCollection Interface

IInfoObjectCollection(TInfo) Interface

IInfoObjectRepository(TCollection) Interface

IInfoProvider Interface

ILicenseService Interface

IMacroSecurityCheckPermissions Interface

ImportExportSettings Class

IMultiObjectQuery Interface

IMultiObjectQuery(TQuery, TInnerQuery, TObject) Interface

IMultiQuery Interface

IMultiQuery(TQuery, TInnerQuery) Interface

IncludeToParentEnum Enumeration

IndexColumn Class

IndexExtensions Class

InfoCollectionSettings Class

InfoDataSet(TInfo) 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

InfoProviderLoader Class

InfoProviderLoader.OnLoadProvider Delegate

IObjectQuery Interface

IObjectQuery(TQuery, TObject) Interface

IObjectTypeDriven Interface

IObjectTypeFilter Interface

IProviderDictionary Interface

IProviderDictionary(TKey, TValue) Interface

IQueryColumn Interface

IQueryExpression Interface

IQueryObject Interface

IQueryObjectWithValue Interface

IQueryParameters Interface

IQueryParameters(TParent) Interface

IQuerySource Interface

IRelatedObjectCountProvider Interface

IsContentFieldEventArgs Class

IsContentFieldHandler Class

ISearchable Interface

ISearchField Interface

ISearchFields Interface

ISearchIndexInfo Interface

IsIndexFieldEventArgs Class

IsIndexFieldHandler Class

ISqlGenerator Interface

ISqlServerCapabilities Interface

IStagingTaskGroup Interface

IStructuredData Interface

IStructuredField Interface

ITableIndexes Interface

ITableManager Interface

ITestableProvider Interface

ITransactionScope Interface

IWebFarmProvider Interface

IWhereCondition Interface

IWhereCondition(TParent) Interface

JoinTypeEnum Enumeration

LayoutHelper Class

LayoutTypeEnum Enumeration

LicenseException 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

ObjectChangeOrderEventArgs Class

ObjectChangeOrderEventArgs(TObject) Class

ObjectChangeOrderHandler Class

ObjectDataEventArgs Class

ObjectDataEventHandler Class

ObjectDependency Class

ObjectDependencyEnum Enumeration

ObjectEventArgs Class

ObjectEventArgs(TObject) Class

ObjectEvents Class

ObjectHandler Class

ObjectHelper Class

ObjectPriorityEnum Enumeration

ObjectProperty Class

ObjectQuery Class

ObjectQuery(TObject) Class

ObjectQueryBase(TQuery, TObject) Class

ObjectQuerySettings Class

ObjectRangeEnum Enumeration

ObjectReference 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

ProviderGuidDictionary Class

ProviderHelper Class

ProviderInfoDictionary(TKey) 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

QueryInfoProvider Class

QueryListInfo Class

QueryMacros Class

QueryName Class

QueryOperator Enumeration

QueryParameters Class

QueryParametersBase(TParent) Class

QueryScopeEnum Enumeration

QuerySource Class

QuerySourceBase(TSource) Class

QuerySourceTable Class

QueryTypeEnum Enumeration

QueryUnaryOperator Enumeration

QueryValueExpression Class

RowNumberColumn Class

SearchAnalyzerTypeEnum Enumeration

SearchDocument Class

SearchDocumentExtensions Class

SearchDocumentParameters Class

SearchField Class

SearchFieldFactory Class

SearchFieldsConstants Class

SearchFieldsExtensions Class

SearchFieldsHelper Class

SearchIndexSettings Class

SearchIndexSettingsInfo Class

SearchSettings Class

SearchSettingsInfo Class

SelectCondition 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

SqlExceptionExtensions 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

SynchronizationObjectSettings Class

SynchronizationObjectSettings.OnProcessID Delegate

SynchronizationSettings Class

SynchronizationTypeEnum Enumeration

SystemColumns Class

SystemViewNames Class

TableManager Class

TaskTypeEnum Enumeration

TempFileInfo Class

TempFileInfoProvider Class

TranslationHelper Class

TranslationParameters Class

TranslationReferenceLoader Class

TraverseObjectSettings Class

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: 11.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) 2017 Kentico Software

Send comments on this topic to support@kentico.com