Class SqlServer2012SqlGenerator
SQL query generator for SQL Server 2012 and newer.
Inheritance
System.Object
System.Linq.Expressions.ExpressionVisitor
SqlServer2012SqlGenerator
Implements
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. |