The Dialect type exposes the following members.

Constructors

  NameDescription
Dialect
The base constructor for Dialect.

Methods

  NameDescription
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
Determines whether the specified Object is equal to the current Object.
(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
GetDialectOverloaded.
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
GetForUpdateStringOverloaded.
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
GetLimitStringOverloaded.
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.)
GetTypeNameOverloaded.
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
RegisterColumnTypeOverloaded.
RegisterFunction
ToString
Returns a String that represents the current Object.
(Inherited from Object.)
UnQuoteOverloaded.

Fields

  NameDescription
DefaultBatchSize
NoBatch
PossibleClosedQuoteChars
PossibleQuoteChars
Characters used for quoting sql identifiers

Properties

  NameDescription
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?

See Also