Namespaces

Types

Type Dialect

Namespace NHibernate.Dialect

Methods

Properties

Fields

Public instance methods

SqlString AddIdentitySelectToInsert(SqlString insertSql, string identityColumn, string tableName)

${WriteSummary(content)}
Parameters
return SqlString ${WriteSummary(content)}
SqlString insertSql a parameterized SQL statement to insert a row into a table.
string identityColumn The column for which the identity generator was specified.
string tableName The name of the table the row is being inserted in.

string AppendLockHint(LockMode lockMode, string tableName)

Parameters
return string
LockMode lockMode
string tableName

SqlString ApplyLocksToSql(SqlString sql, IDictionary aliasedLockModes, IDictionary keyColumnNames)

Parameters
return SqlString
SqlString sql
IDictionary aliasedLockModes
IDictionary keyColumnNames

CaseFragment CreateCaseFragment()

Create an CaseFragment for this dialect
Parameters
return CaseFragment

JoinFragment CreateOuterJoinFragment()

Create an JoinFragment for this dialect
Parameters
return JoinFragment

bool Equals(object obj)

Parameters
return bool
object obj

string GetAddForeignKeyConstraintString(string constraintName, String[] foreignKey, string referencedTable, String[] primaryKey)

Parameters
return string
string constraintName
String[] foreignKey
string referencedTable
String[] primaryKey

string GetAddPrimaryKeyConstraintString(string constraintName)

The syntax used to add a primary key constraint to a table
Parameters
return string
string constraintName

string GetCastTypeName(SqlType sqlType)

Parameters
return string
SqlType sqlType

string GetCreateSequenceString(string sequenceName)

The syntax used to create a sequence, if sequences are supported
Parameters
return string
string sequenceName

string GetDropForeignKeyConstraintString(string constraintName)

The syntax used to drop a foreign key constraint from a table.
Parameters
return string The SQL string to drop the foreign key constraint.
string constraintName The name of the foreign key constraint to drop.

string GetDropIndexConstraintString(string constraintName)

The syntax used to drop an index constraint from a table.
Parameters
return string The SQL string to drop the primary key constraint.
string constraintName The name of the index constraint to drop.

string GetDropPrimaryKeyConstraintString(string constraintName)

The syntax used to drop a primary key constraint from a table.
Parameters
return string The SQL string to drop the primary key constraint.
string constraintName The name of the primary key constraint to drop.

string GetDropSequenceString(string sequenceName)

The syntax used to drop a sequence, if sequences are supported
Parameters
return string
string sequenceName

string GetDropTableString(string tableName)

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

string GetForUpdateNowaitString(string aliases)

Parameters
return string
string aliases

string GetForUpdateString(string aliases)

Parameters
return string
string aliases

string GetForUpdateString(LockMode lockMode)

Parameters
return string
LockMode lockMode

int GetHashCode()

Parameters
return int

string GetIdentitySelectString(string identityColumn, string tableName)

The syntax that returns the identity value of the last insert, if native key generation is supported
Parameters
return string
string identityColumn
string tableName

SqlString GetLimitString(SqlString querySqlString, bool hasOffset)

Add a LIMIT clause to the given SQL SELECT
Parameters
return SqlString A new SqlString that contains the LIMIT clause.
SqlString querySqlString A Query in the form of a SqlString.
bool hasOffset Offset of the first row is not zero

SqlString GetLimitString(SqlString querySqlString, int offset, int limit)

Add a LIMIT clause to the given SQL SELECT
Parameters
return SqlString A new SqlString that contains the LIMIT clause.
SqlString querySqlString A Query in the form of a SqlString.
int offset Offset of the first row to be returned by the query (zero-based)
int limit Maximum number of rows to be returned by the query

string GetSequenceNextValString(string sequenceName)

The syntax that fetches the next value of a sequence, if sequences are supported.
Parameters
return string
string sequenceName The name of the sequence

Type GetType()

Parameters
return Type

string GetTypeName(SqlType sqlType)

Get the name of the database type associated with the given SqlType ,
Parameters
return string The database type name used by ddl.
SqlType sqlType The SqlType

string GetTypeName(SqlType sqlType, int length)

Get the name of the database type associated with the given SqlType .
Parameters
return string The database type name used by ddl.
SqlType sqlType The SqlType
int length The length of the SqlType

bool IsQuoted(string name)

Checks to see if the name has been quoted.
The default implementation is to compare the first character to Dialect.OpenQuote and the last char to Dialect.CloseQuote
Parameters
return bool true if name is already quoted.
string name The name to check if it is quoted

string QuoteForAliasName(string aliasName)

Quotes a name for being used as a aliasname
Original implementation calls QuoteForTableName
Parameters
return string A Quoted name in the format of OpenQuote + aliasName + CloseQuote
string aliasName Name of the alias

string QuoteForColumnName(string columnName)

Quotes a name for being used as a columnname
Original implementation calls QuoteForTableName
Parameters
return string A Quoted name in the format of OpenQuote + columnName + CloseQuote
string columnName Name of the column

string QuoteForSchemaName(string schemaName)

Quotes a name for being used as a schemaname
Parameters
return string A Quoted name in the format of OpenQuote + schemaName + CloseQuote
string schemaName Name of the schema

string QuoteForTableName(string tableName)

Quotes a name for being used as a tablename
Parameters
return string A Quoted name in the format of OpenQuote + tableName + CloseQuote
string tableName Name of the table

string ToString()

Parameters
return string

string UnQuote(string quoted)

Unquotes and unescapes an already quoted name
Parameters
return string Unquoted string
string quoted Quoted string

String[] UnQuote(String[] quoted)

Parameters
return String[]
String[] quoted

Public static methods

Dialect GetDialect()

Parameters
return Dialect

Dialect GetDialect(IDictionary props)

Parameters
return Dialect
IDictionary props

Public properties

string AddColumnString get;

The syntax used to add a column to a table. Note this is deprecated
return string

bool BindLimitParametersFirst get;

Does the LIMIT clause come at the start of the SELECT statement rather than at the end?
return bool

bool BindLimitParametersInReverseOrder get;

Does the LIMIT clause specify arguments in the "reverse" order limit, offset instead of offset, limit?
Inheritors should return true if the correct order is limit, offset
return bool

Char CloseQuote get;

The closing quote for a quoted identifier.
return Char

IDictionary DefaultProperties get;

Retrieve a set of default Hibernate properties for this database.
return IDictionary

bool DropConstraints get;

Do we need to drop constraints before dropping tables in the dialect?
return bool

string ForUpdateNowaitString get;

Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect
return string

bool ForUpdateOfColumns get;

return bool

string ForUpdateString get;

Retrieves the FOR UPDATE syntax specific to this dialect
return string

IDictionary Functions get;

Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!
The results of this method should be integrated with the specialization's data.
return IDictionary

bool HasAlterTable get;

Does this dialect support the ALTER TABLE syntax?
return bool

bool HasDataTypeInIdentityColumn get;

Whether this dialect has an identity clause added to the data type or a completely seperate identity data type.
return bool

string IdentityColumnString get;

The keyword used to specify an identity column, if native key generation is supported
return string

string IdentityInsertString get;

The keyword used to insert a generated value into an identity column (or null)
return string

string LowercaseFunction get;

The name of the SQL function that transforms a string to lowercase
return string

int MaxAliasLength get;

return int

string MultipleQueriesSeparator get;

How we seperate the queries when we use multiply queries.
return string

string NoColumnsInsertString get;

The keyword used to insert a row without specifying any column values
return string

string NullColumnString get;

The keyword used to specify a nullable column
return string

Char OpenQuote get;

The opening quote for a quoted identifier.
return Char

bool QualifyIndexName get;

Do we need to qualify index names with the schema name?
return bool

bool SupportsIdentityColumns get;

Does this dialect support identity column key generation?
return bool

bool SupportsLimit get;

Does this Dialect have some kind of LIMIT syntax?
return bool

bool SupportsLimitOffset get;

Does this Dialect support an offset?
return bool

bool SupportsSequences get;

Does this dialect support sequences?
return bool

bool SupportsSubSelects get;

Does this dialect support subselects?
return bool

bool SupportsUnique get;

Does this dialect support the UNIQUE column syntax?
return bool

bool SupportsVariableLimit get;

Can parameters be used for a statement containing a LIMIT?
return bool

long TimestampResolutionInTicks get;

Gives the best resolution that the database can use for storing date/time values, in ticks.
Docu.Documentation.Comments.Paragraph Docu.Documentation.Comments.Paragraph
return long

bool UseMaxForLimit get;

Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?
return bool

Public fields

string PossibleQuoteChars

Characters used for quoting sql identifiers
return string

string PossibleClosedQuoteChars

return string