C# Class NHibernate.JetDriver.JetDialect

Dialect for Jet database engine.

Inheritance: Dialect.Dialect

Public Methods

Method	Description
CreateCaseFragment ( ) : NHibernate.SqlCommand.CaseFragment	Create an `CaseFragment` for this dialect
CreateOuterJoinFragment ( ) : NHibernate.SqlCommand.JoinFragment
GetIdentitySelectString ( string identityColumn, string tableName, DbType type ) : string
GetLimitString ( NHibernate.SqlCommand.SqlString querySqlString, int offset, int limit ) : NHibernate.SqlCommand.SqlString	MS Access and SQL Server support limit. This implementation has been made according the MS Access syntax
JetDialect ( ) : System
ToBooleanValueString ( bool value ) : string	The SQL literal value to which this database maps boolean values.
UnQuote ( string quoted ) : string

Method	Description
Quote ( string name ) : string	MsSql does not require the OpenQuote to be escaped as long as the first char is an OpenQuote.

Create an CaseFragment for this dialect

public CreateCaseFragment ( ) : NHibernate.SqlCommand.CaseFragment
return	NHibernate.SqlCommand.CaseFragment

public CreateOuterJoinFragment ( ) : NHibernate.SqlCommand.JoinFragment
return	NHibernate.SqlCommand.JoinFragment

public GetIdentitySelectString ( string identityColumn, string tableName, DbType type ) : string
identityColumn	string
tableName	string
type	DbType
return	string

MS Access and SQL Server support limit. This implementation has been made according the MS Access syntax

public GetLimitString ( NHibernate.SqlCommand.SqlString querySqlString, int offset, int limit ) : NHibernate.SqlCommand.SqlString
querySqlString	NHibernate.SqlCommand.SqlString	The original query
offset	int	Specifies the number of rows to skip, before starting to return rows from the query expression.
limit	int	Is used to limit the number of results returned in a SQL statement
return	NHibernate.SqlCommand.SqlString

public JetDialect ( ) : System
return	System

MsSql does not require the OpenQuote to be escaped as long as the first char is an OpenQuote.

protected Quote ( string name ) : string
name	string
return	string

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

public ToBooleanValueString ( bool value ) : string
value	bool	The boolean value
return	string

public UnQuote ( string quoted ) : string
quoted	string
return	string