Class SqlServer2008SqlGenerator

SQL query generator for SQL Server 2008 and newer.

Inheritance
System.Object
System.Linq.Expressions.ExpressionVisitor
DefaultQuerySqlGenerator
SqlServer2008SqlGenerator
Inherited Members
Namespace: Kros.KORM.Query.Sql
Assembly: Kros.KORM.dll
Syntax
public class SqlServer2008SqlGenerator : DefaultQuerySqlGenerator, ISqlExpressionVisitor
Remarks

Offset (Skip) and limit (Top) are translated to CTE (Common Table Expression).

Constructors

SqlServer2008SqlGenerator(IDatabaseMapper)

Creates an instance of the generator with specified database mapper databaseMapper.

Declaration
public SqlServer2008SqlGenerator(IDatabaseMapper databaseMapper)
Parameters
Type Name Description
IDatabaseMapper databaseMapper

Database mapper

Methods

AddLimitAndOffset()

Declaration
protected override void AddLimitAndOffset()
Overrides

AddOrderBy()

Declaration
protected override void AddOrderBy()
Overrides

CreateQueryReader()

Returns null.

Declaration
protected override IDataReaderEnvelope CreateQueryReader()
Returns
Type Description
IDataReaderEnvelope

Returns null.
Overrides

Implements