C# Класс MicroLite.Dialect.SqlDialect

The base class for implementations of ISqlDialect.

Наследование: ISqlDialect

Открытые методы

Метод	Описание
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.

Метод	Описание
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.
Результат	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.
Результат	SqlQuery

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

protected BuildInsertCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Результат	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.
Результат	SqlQuery

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

protected BuildSelectCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Результат	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.
Результат	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.
Результат	SqlQuery

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

protected BuildUpdateCommandText ( IObjectInfo objectInfo ) : string
objectInfo	IObjectInfo	The object information.
Результат	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.
Результат	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.
Результат	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.
Результат	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.
Результат	SqlQuery

Initialises a new instance of the SqlDialect class.

protected SqlDialect ( SqlCharacters sqlCharacters ) : System
sqlCharacters	SqlCharacters	The SQL characters.
Результат	System