Enum DialectOptions

SQL dialect options

Namespace: XData
Assembly: XData.docfx.dll
Syntax
[Flags]
public enum DialectOptions : ulong

Fields

Name Description
CheckConcurrencySupport

Concurrency check supported
ClearByRowIdArrays

Clear statement used row id arrays
InternalErrorCatch

Concurrency SQL errors are handled and jammed in provider
MultipleRecordsetProceduresSupported

Multiple record set stored procedures are supported
None

No specific SQL dialect options declared
ObjectParametersSupported

User defined objects (UDT) are supported as procedure/function parameter types
RegisterRecordsetRequired

Output record set registering is required
ReturningInResult

Insert returned identity value as query result
RowIteratorSupported

Row iterator is supported
SafeTypeConvert

Safe type conversion required
ScalarFunctionsOutParametersAllowed

Scalar-valued SQL functions OUT parameters are supported
ScalarFunctionsSupported

Scalar-valued SQL functions are supported
SequenceRequired

Sequence is required to auto increment fields
SequenceSupported

Sequences are supported
SqlBlockOuterTableVariables

Sql block can operate with table variables out of block only
StoredProcedureResultAsExecuteScalar

SQL function result value returned as Execute scalar result
StoredProcedureResultFetch

Stored procedure results fetched by multiple reader execute
StoredProceduresSupported

SQL stored procedures are supported
TableFunctionsSupported

Table-valued SQL functions are supported
TableOutParametersAllowed

Table types are supported as procedure/function OUT parameter types
TableParametersSupported

Table types are supported as procedure/function parameter types
TempTableNotSupported

Temp Table is not supported
UdtAsReturnValueSupported

SQL function can return UDT or Arrays

UpdateSubqueryFields

Update can use subquery fields as update source values and target fields
UpdateTableNotInFrom

Update table is part of update (or delete) statement and not listed in from statement
UpdateTableNotUseAlias

Update and delete statements only for one table and not use table alias
UpdateUseTableNames

Update not use table aliases but lower case table names
WithInsideSubqueryNotSupported

Common-Table-Expression (WITH) queries not supported inside subqueries
WithSupported

Common-Table-Expression (WITH) queries are supported
WithUnionNotSupported

Common-Table-Expression (WITH) recursive queries combination with UNION operation not supported
XmlSourceSupported

XML data source is supported

Extension Methods