Class SqlServer2012SqlGenerator

SQL query generator for SQL Server 2012 and newer.

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

Offset (Skip) and limit (Top) are translated to SQL server 2012 syntax: OFFSET n ROWS FETCH NEXT m ROWS ONLY.

Constructors

SqlServer2012SqlGenerator(IDatabaseMapper)

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

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

Database mapper

Methods

AddLimitAndOffset()

Declaration
protected override void AddLimitAndOffset()
Overrides

CreateQueryReader()

Returns null.

Declaration
protected override IDataReaderEnvelope CreateQueryReader()
Returns
Type Description
IDataReaderEnvelope

Returns null.
Overrides

Implements