Add the Identity Select string to the Insert Sql. Not supported by Access.

Create an CaseFragment for this dialect

(Inherited from Dialect.)

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

The syntax used to create a sequence, if sequences are supported

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.

The syntax used to drop a sequence, if sequences are supported

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

(Overrides .GetIdentitySelectString(String, String).)

The syntax that fetches the next value of a sequence, if sequences are supported.

Checks to see if the name has been quoted.

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

(Overrides .UnQuote(String).)

(Overrides .Quote(String).)

(Inherited from Dialect.)

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

Does the LIMIT clause specify arguments in the "reverse" order limit, offset instead of offset, limit?

(Overrides .CloseQuote.)

Retrieve a set of default Hibernate properties for this database.

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

Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect

Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!

Does this dialect support the ALTER TABLE syntax?

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

Access is not conforming to standards of other databases in identity/autoincrement columns specifications. Instead of something like "INT NOT NULL AUTO_INCREMENT" for MySQL or "INT IDENTITY NOT NULL" for MsSQL, Access autoincremented column has a special datatype - COUNTER. This is not compatible with NHibernate way of doing things, so I define some non-SQL string, that is translated in the JetDbCommand..

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

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

How we seperate the queries when we use multiply queries.

(Overrides .NoColumnsInsertString.)

(Overrides .OpenQuote.)

(Overrides .SupportsIdentityColumns.)

Does this Dialect have some kind of LIMIT syntax?

Does this Dialect support an offset?

Does this dialect support sequences?

Does this dialect support subselects?

Does this dialect support the UNIQUE column syntax?

Can parameters be used for a statement containing a LIMIT?

Gives the best resolution that the database can use for storing date/time values, in ticks.

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

Completely optional cascading drop clause

Does the dialect support the syntax 'drop table NAME if exists'

Does the dialect support the syntax 'drop table if exists NAME'