Provided we SupportsInsertSelectIdentity, then attch the "select identity" clause to the insert statement.

Some dialects support an alternative means to SELECT FOR UPDATE, whereby a "lock hint" is appends to the table name in the from clause.

Modifies the given SQL by applying the appropriate updates for the specified lock modes and key columns.

Build an instance of the ISQLExceptionConverter preferred by this dialect for converting DbException into NHibernate's ADOException hierarchy.

Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.

Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.

Do we need to drop the temporary table after use?

Determines whether the specified Object is equal to the current Object.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Generate a temporary table name given the bas table.

The syntax used to add a foreign key constraint to a table. If SupportsForeignKeyConstraintInAlterTable is false, the returned string will be added to the create table statement instead. In this case, extra strings, like "add", that apply when using alter table should be omitted.

The syntax used to add a primary key constraint to a table

Get the name of the database type appropriate for casting operations (via the CAST() SQL function) for the given SqlType typecode.

Typically dialects which support sequences can create a sequence with a single command.

Overloaded form of GetCreateSequenceString(String), additionally taking the initial value and increment size to be applied to the sequence definition.

An optional multi-line form for databases which SupportsPooledSequences.

Get an instance of the dialect specified by the current Environment properties.

Get de Dialect from a property bag (prop name Dialect)

The syntax used to drop a foreign key constraint from a table.

The syntax used to drop an index constraint from a table.

The syntax used to drop a primary key constraint from a table.

Typically dialects which support sequences can drop a sequence with a single command.

The multiline script used to drop a sequence.

Return SQL needed to drop the named table. May (and should) use some form of "if exists" clause, and cascade constraints.

Get the FOR UPDATE OF column_list NOWAIT fragment appropriate for this dialect given the aliases of the columns to be write locked.

Get the FOR UPDATE OF column_list fragment appropriate for this dialect given the aliases of the columns to be write locked.

Given a lock mode, determine the appropriate for update fragment to use.

Serves as a hash function for a particular type.

Get the name of the Hibernate IType associated with th given DbType typecode.

Get the name of the Hibernate IType associated with the given DbType typecode with the given storage specification parameters.

The syntax used during DDL to define a column as being an IDENTITY of a particular type.

Get the select command to use to retrieve the last generated IDENTITY value for a particular table

The syntax that is used to check if a constraint exists before dropping it

The syntax that is used to close the if for a constraint exists check, used for dialects that requires begin/end for ifs

The syntax that is used to check if a constraint does not exists before creating it

The syntax that is used to close the if for a constraint exists check, used for dialects that requires begin/end for ifs

Add a LIMIT clause to the given SQL SELECT. Expects any database-specific offset and limit adjustments to have already been performed (ex. UseMaxForLimit, OffsetStartsAtOne).

Generates a string to limit the result set to a number of maximum results with a specified offset into the results. Expects any database-specific offset and limit adjustments to have already been performed (ex. UseMaxForLimit, OffsetStartsAtOne). Performs error checking based on the various dialect limit support options. If both parameters and fixed valeus are specified, this will use the parameter option if possible. Otherwise, it will fall back to a fixed string.

Some databases require that a limit statement contain the maximum row number instead of the number of rows to retrieve. This method adjusts source limit and offset values to account for this.

Get a strategy instance which knows how to acquire a database-level lock of the specified mode for this dialect.

Gets the name of the longest registered type for a particular DbType.

Some databases use limit row offsets that start at one instead of zero. This method adjusts a desired offset using the OffsetStartsAtOne flag.

Given a callable statement previously processed by RegisterResultSetOutParameter(DbCommand, Int32), extract the DbDataReader from the OUT parameter.

Given a DbType type code, determine an appropriate null value to use in a select clause.

Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement.

Generate the appropriate select statement to to retreive the next value of a sequence.

Gets the Type of the current instance.

Get the name of the database type associated with the given SqlType,

Get the name of the database type associated with the given SqlType.

Checks to see if the name has been quoted.

Creates a shallow copy of the current Object.

Does the dialect require that temporary table DDL statements occur in isolation from other statements? This would be the case if the creation would cause any current transaction to get committed implicitly.

Quotes a name.

Quotes a name for being used as a aliasname

Quotes a name for being used as a columnname

Quotes a name for being used as a schemaname

Quotes a name for being used as a tablename

Suclasses register a typename for the given type code. $l in the typename will be replaced by the column length (if appropriate).

Subclasses register a typename for the given type code and maximum column length. $l in the type name will be replaced by the column length (if appropriate)

Registers a Hibernate IType name for the given DbType type code.

Registers a Hibernate IType name for the given DbType type code and maximum column length.

Registers an OUT parameter which will be returing a DbDataReader. How this is accomplished varies greatly from DB to DB, hence its inclusion (along with {@link #getResultSet}) here.

The SQL literal value to which this database maps boolean values.

Returns a string that represents the current object.

Unquotes and unescapes an already quoted name

Unquotes an array of Quoted Names.

Apply a "between" constraint to the named property Note: throws an exception outside of a QueryOver expression

Apply an "in" constraint to the named property Note: throws an exception outside of a QueryOver expression

Apply an "in" constraint to the named property Note: throws an exception outside of a QueryOver expression