The Dialect type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() | Dialect |
The base constructor for Dialect.
|
Methods
Name | Description | |
---|---|---|
![]() | AddIdentitySelectToInsert |
Generate SQL to get the identifier of an inserted row.
If the returned value is not null, the caller will prepare a statement from it,
set SQL parameters just as it would for insertSQL, and execute it as a query
which is expected to return the identifier of the inserted row.
If the returned value is null, the caller will execute insertSQL as an update
and then execute IdentitySelectString as a query.
The default implementation (in this class) returns nullNothingnullptra null reference (Nothing in Visual Basic).
|
![]() | AppendLockHint | |
![]() | ApplyLocksToSql | |
![]() | CreateCaseFragment |
Create an CaseFragment for this dialect
|
![]() | CreateOuterJoinFragment |
Create an JoinFragment for this dialect
|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetAddForeignKeyConstraintString | |
![]() | GetAddPrimaryKeyConstraintString |
The syntax used to add a primary key constraint to a table
|
![]() | GetCastTypeName | |
![]() | GetCreateSequenceString |
The syntax used to create a sequence, if sequences are supported
|
![]() ![]() | GetDialect | Overloaded. |
![]() | GetDropForeignKeyConstraintString |
The syntax used to drop a foreign key constraint from a table.
|
![]() | GetDropIndexConstraintString |
The syntax used to drop an index constraint from a table.
|
![]() | GetDropPrimaryKeyConstraintString |
The syntax used to drop a primary key constraint from a table.
|
![]() | GetDropSequenceString |
The syntax used to drop a sequence, if sequences are supported
|
![]() | GetDropTableString |
Return SQL needed to drop the named table. May (and should) use
some form of "if exists" clause, and cascade constraints.
|
![]() | GetForUpdateNowaitString | |
![]() | GetForUpdateString | Overloaded. |
![]() | GetHashCode | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
![]() | GetIdentitySelectString |
The syntax that returns the identity value of the last insert, if native
key generation is supported
|
![]() | GetLimitString | Overloaded. |
![]() | GetSequenceNextValString |
The syntax that fetches the next value of a sequence, if sequences are supported.
|
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | GetTypeName | Overloaded. |
![]() | IsQuoted |
Checks to see if the name has been quoted.
|
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | Quote |
Quotes a name.
|
![]() | QuoteForAliasName |
Quotes a name for being used as a aliasname
|
![]() | QuoteForColumnName |
Quotes a name for being used as a columnname
|
![]() | QuoteForSchemaName |
Quotes a name for being used as a schemaname
|
![]() | QuoteForTableName |
Quotes a name for being used as a tablename
|
![]() | RegisterColumnType | Overloaded. |
![]() | RegisterFunction | |
![]() | ToString | (Inherited from Object.) |
![]() | UnQuote | Overloaded. |
Fields
Name | Description | |
---|---|---|
![]() ![]() | DefaultBatchSize | |
![]() ![]() | NoBatch | |
![]() ![]() | PossibleClosedQuoteChars | |
![]() ![]() | PossibleQuoteChars |
Characters used for quoting sql identifiers
|
Properties
Name | Description | |
---|---|---|
![]() | AddColumnString |
The syntax used to add a column to a table. Note this is deprecated
|
![]() | BindLimitParametersFirst |
Does the LIMIT clause come at the start of the
SELECT statement rather than at the end?
|
![]() | BindLimitParametersInReverseOrder |
Does the LIMIT clause specify arguments in the "reverse" order
limit, offset instead of offset, limit?
|
![]() | CascadeConstraintsString |
Completely optional cascading drop clause
|
![]() | CloseQuote |
The closing quote for a quoted identifier.
|
![]() | DefaultProperties |
Retrieve a set of default Hibernate properties for this database.
|
![]() | DropConstraints |
Do we need to drop constraints before dropping tables in the dialect?
|
![]() | ForUpdateNowaitString |
Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect
|
![]() | ForUpdateOfColumns | |
![]() | ForUpdateString |
Retrieves the FOR UPDATE syntax specific to this dialect
|
![]() | Functions |
Aggregate SQL functions as defined in general. This is
a case-insensitive hashtable!
|
![]() | HasAlterTable |
Does this dialect support the ALTER TABLE syntax?
|
![]() | HasDataTypeInIdentityColumn |
Whether this dialect has an identity clause added to the data type or a
completely seperate identity data type.
|
![]() | IdentityColumnString |
The keyword used to specify an identity column, if native key generation is supported
|
![]() | IdentityInsertString |
The keyword used to insert a generated value into an identity column (or null)
|
![]() | LowercaseFunction |
The name of the SQL function that transforms a string to lowercase
|
![]() | MaxAliasLength | |
![]() | MultipleQueriesSeparator |
How we seperate the queries when we use multiply queries.
|
![]() | NoColumnsInsertString |
The keyword used to insert a row without specifying any column values
|
![]() | NullColumnString |
The keyword used to specify a nullable column
|
![]() | OpenQuote |
The opening quote for a quoted identifier.
|
![]() | QualifyIndexName |
Do we need to qualify index names with the schema name?
|
![]() | SupportsIdentityColumns |
Does this dialect support identity column key generation?
|
![]() | SupportsIfExistsAfterTableName |
Does the dialect support the syntax 'drop table NAME if exists'
|
![]() | SupportsIfExistsBeforeTableName |
Does the dialect support the syntax 'drop table if exists NAME'
|
![]() | SupportsLimit |
Does this Dialect have some kind of LIMIT syntax?
|
![]() | SupportsLimitOffset |
Does this Dialect support an offset?
|
![]() | SupportsSequences |
Does this dialect support sequences?
|
![]() | SupportsSubSelects |
Does this dialect support subselects?
|
![]() | SupportsUnique |
Does this dialect support the UNIQUE column syntax?
|
![]() | SupportsVariableLimit |
Can parameters be used for a statement containing a LIMIT?
|
![]() | TimestampResolutionInTicks |
Gives the best resolution that the database can use for storing
date/time values, in ticks.
|
![]() | UseMaxForLimit |
Does the LIMIT clause take a "maximum" row number
instead of a total number of returned rows?
|