C# Class MicroLite.Dialect.SqlDialect

The base class for implementations of ISqlDialect.
Inheritance: ISqlDialect
Mostra file Open project: TrevorPilley/MicroLite

Public Methods

Method 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.

Protected Methods

Method 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.

Method Details

BuildDeleteCommandText() protected method

Builds the command text to delete a database record for the specified IObjectInfo.
protected BuildDeleteCommandText ( IObjectInfo objectInfo ) : string
objectInfo IObjectInfo The object information.
return string

BuildDeleteSqlQuery() public method

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.
return SqlQuery

BuildInsertCommandText() protected method

Builds the command text to insert a database record for the specified IObjectInfo.
protected BuildInsertCommandText ( IObjectInfo objectInfo ) : string
objectInfo IObjectInfo The object information.
return string

BuildInsertSqlQuery() public method

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.
return SqlQuery

BuildSelectCommandText() protected method

Builds the command text to select a database record for the specified IObjectInfo.
protected BuildSelectCommandText ( IObjectInfo objectInfo ) : string
objectInfo IObjectInfo The object information.
return string

BuildSelectInsertIdSqlQuery() public method

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.
return SqlQuery

BuildSelectSqlQuery() public method

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.
return SqlQuery

BuildUpdateCommandText() protected method

Builds the command text to update a database record for the specified IObjectInfo.
protected BuildUpdateCommandText ( IObjectInfo objectInfo ) : string
objectInfo IObjectInfo The object information.
return string

BuildUpdateSqlQuery() public method

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.
return SqlQuery

BuildUpdateSqlQuery() public method

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.
return SqlQuery

CountQuery() public method

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.
return SqlQuery

PageQuery() public abstract method

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.
return SqlQuery

SqlDialect() protected method

Initialises a new instance of the SqlDialect class.
protected SqlDialect ( SqlCharacters sqlCharacters ) : System
sqlCharacters SqlCharacters The SQL characters.
return System