C# Class MicroLite.Dialect.SqlDialect

The base class for implementations of ISqlDialect.

Inheritance: ISqlDialect

Méthodes publiques

Méthode	Description
BuildDeleteSqlQuery ( IObjectInfo objectInfo, object identifier ) : SqlQuery	Builds an SqlQuery to delete the database record with the specified identifier for the type specified by the IObjectInfo.
BuildInsertSqlQuery ( IObjectInfo objectInfo, object instance ) : SqlQuery	Builds an SqlQuery to insert a database record for the specified instance with the current property values of the instance.
BuildSelectInsertIdSqlQuery ( IObjectInfo objectInfo ) : SqlQuery	Builds an SqlQuery to select the identity of an inserted object if the database supports Identity or AutoIncrement.
BuildSelectSqlQuery ( IObjectInfo objectInfo, object identifier ) : SqlQuery	Builds an SqlQuery to select the database record with the specified identifier for the type specified by the IObjectInfo.
BuildUpdateSqlQuery ( IObjectInfo objectInfo, object instance ) : SqlQuery	Builds an SqlQuery to update the database record for the specified instance with the current property values of the instance.
BuildUpdateSqlQuery ( ObjectDelta objectDelta ) : SqlQuery	Creates an SqlQuery to perform an update based upon the values in the object delta.
CountQuery ( SqlQuery sqlQuery ) : SqlQuery	Creates an SqlQuery to count the number of records which would be returned by the specified SqlQuery.
PageQuery ( SqlQuery sqlQuery, PagingOptions pagingOptions ) : SqlQuery	Creates an SqlQuery to page the records which would be returned by the specified SqlQuery based upon the paging options.

Méthode	Description
BuildDeleteCommandText ( IObjectInfo objectInfo ) : string	Builds the command text to delete a database record for the specified IObjectInfo.
BuildInsertCommandText ( IObjectInfo objectInfo ) : string	Builds the command text to insert a database record for the specified IObjectInfo.
BuildSelectCommandText ( IObjectInfo objectInfo ) : string	Builds the command text to select a database record for the specified IObjectInfo.
BuildUpdateCommandText ( IObjectInfo objectInfo ) : string	Builds the command text to update a database record for the specified IObjectInfo.
SqlDialect ( SqlCharacters sqlCharacters ) : System	Initialises a new instance of the SqlDialect class.

Builds the command text to delete a database record for the specified IObjectInfo.

protected BuildDeleteCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Résultat	string

Builds an SqlQuery to delete the database record with the specified identifier for the type specified by the IObjectInfo.

public BuildDeleteSqlQuery ( IObjectInfo objectInfo, object identifier ) : SqlQuery
objectInfo	IObjectInfo	The object information.
identifier	object	The identifier of the instance to delete.
Résultat	SqlQuery

Builds the command text to insert a database record for the specified IObjectInfo.

protected BuildInsertCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Résultat	string

Builds an SqlQuery to insert a database record for the specified instance with the current property values of the instance.

public BuildInsertSqlQuery ( IObjectInfo objectInfo, object instance ) : SqlQuery
objectInfo	IObjectInfo	The object information.
instance	object	The instance to insert.
Résultat	SqlQuery

Builds the command text to select a database record for the specified IObjectInfo.

protected BuildSelectCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Résultat	string

Builds an SqlQuery to select the identity of an inserted object if the database supports Identity or AutoIncrement.

public BuildSelectInsertIdSqlQuery ( IObjectInfo objectInfo ) : SqlQuery
objectInfo	IObjectInfo	The object information.
Résultat	SqlQuery

Builds an SqlQuery to select the database record with the specified identifier for the type specified by the IObjectInfo.

public BuildSelectSqlQuery ( IObjectInfo objectInfo, object identifier ) : SqlQuery
objectInfo	IObjectInfo	The object information.
identifier	object	The identifier of the instance to select.
Résultat	SqlQuery

Builds the command text to update a database record for the specified IObjectInfo.

protected BuildUpdateCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Résultat	string

Builds an SqlQuery to update the database record for the specified instance with the current property values of the instance.

public BuildUpdateSqlQuery ( IObjectInfo objectInfo, object instance ) : SqlQuery
objectInfo	IObjectInfo	The object information.
instance	object	The instance to update.
Résultat	SqlQuery

Creates an SqlQuery to perform an update based upon the values in the object delta.

public BuildUpdateSqlQuery ( ObjectDelta objectDelta ) : SqlQuery
objectDelta	ObjectDelta	The object delta to create the query for.
Résultat	SqlQuery

Creates an SqlQuery to count the number of records which would be returned by the specified SqlQuery.

public CountQuery ( SqlQuery sqlQuery ) : SqlQuery
sqlQuery	SqlQuery	The SQL query.
Résultat	SqlQuery

Creates an SqlQuery to page the records which would be returned by the specified SqlQuery based upon the paging options.

public abstract PageQuery ( SqlQuery sqlQuery, PagingOptions pagingOptions ) : SqlQuery
sqlQuery	SqlQuery	The SQL query.
pagingOptions	PagingOptions	The paging options.
Résultat	SqlQuery

Initialises a new instance of the SqlDialect class.

protected SqlDialect ( SqlCharacters sqlCharacters ) : System
sqlCharacters	SqlCharacters	The SQL characters.
Résultat	System