Show / Hide Table of Contents

    Class SqlServer2012SqlGenerator

    SQL query generator for SQL Server 2012 and newer.

    Inheritance
    System.Object
    System.Linq.Expressions.ExpressionVisitor
    DefaultQuerySqlGenerator
    SqlServer2012SqlGenerator
    Implements
    ISqlExpressionVisitor
    Inherited Members
    DefaultQuerySqlGenerator.SqlTrue
    DefaultQuerySqlGenerator.SqlFalse
    DefaultQuerySqlGenerator.DatabaseMapper
    DefaultQuerySqlGenerator.GenerateSql(Expression)
    DefaultQuerySqlGenerator.GenerateWhereCondition(Expression, String)
    DefaultQuerySqlGenerator.Orders
    DefaultQuerySqlGenerator.SqlBuilder
    DefaultQuerySqlGenerator.Skip
    DefaultQuerySqlGenerator.Top
    DefaultQuerySqlGenerator.TopPosition
    DefaultQuerySqlGenerator.ColumnsPosition
    DefaultQuerySqlGenerator.AddOrderBy()
    DefaultQuerySqlGenerator.CreateOrderByString()
    DefaultQuerySqlGenerator.BindAnyCondition(String)
    DefaultQuerySqlGenerator.VisitSql(SqlExpression)
    DefaultQuerySqlGenerator.VisitSelect(SelectExpression)
    DefaultQuerySqlGenerator.VisitColumns(ColumnsExpression)
    DefaultQuerySqlGenerator.VisitTable(TableExpression)
    DefaultQuerySqlGenerator.VisitWhere(WhereExpression)
    DefaultQuerySqlGenerator.VisitGroupBy(GroupByExpression)
    DefaultQuerySqlGenerator.VisitOrderBy(OrderByExpression)
    DefaultQuerySqlGenerator.PreviousMemberExpression
    DefaultQuerySqlGenerator.MemberExpressionStack
    DefaultQuerySqlGenerator.SelectExpression
    DefaultQuerySqlGenerator.LinqStringBuilder
    DefaultQuerySqlGenerator.AddParameterWithValue(Object)
    DefaultQuerySqlGenerator.LinqParameters
    DefaultQuerySqlGenerator.Visit(Expression)
    DefaultQuerySqlGenerator.VisitMethodCall(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitVbOperatorsMethods(MethodCallExpression, ExpressionType)
    DefaultQuerySqlGenerator.VisitCompare(MethodCallExpression, ExpressionType)
    DefaultQuerySqlGenerator.VisitLinqExpression(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitAny(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitSkip(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitTake(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitAggregate(MethodCallExpression, String)
    DefaultQuerySqlGenerator.VisitCount(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitWhere(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitFirst(MethodCallExpression)
    DefaultQuerySqlGenerator.VisitUnary(UnaryExpression)
    DefaultQuerySqlGenerator.VisitBinary(BinaryExpression)
    DefaultQuerySqlGenerator.GetOperator(BinaryExpression)
    DefaultQuerySqlGenerator.VisitConstant(ConstantExpression)
    DefaultQuerySqlGenerator.GetConstantExpressionValue(ConstantExpression)
    DefaultQuerySqlGenerator.VisitMember(MemberExpression)
    DefaultQuerySqlGenerator.VisitStringMethods(MethodCallExpression)
    DefaultQuerySqlGenerator.BindTrim(MethodCallExpression)
    DefaultQuerySqlGenerator.BindSubstring(MethodCallExpression)
    DefaultQuerySqlGenerator.BindReplace(MethodCallExpression)
    DefaultQuerySqlGenerator.BindToLower(MethodCallExpression)
    DefaultQuerySqlGenerator.BindToUpper(MethodCallExpression)
    DefaultQuerySqlGenerator.BindIsNullOrEmpty(MethodCallExpression)
    DefaultQuerySqlGenerator.BindContains(MethodCallExpression)
    DefaultQuerySqlGenerator.BindEndWith(MethodCallExpression)
    DefaultQuerySqlGenerator.BindStartWith(MethodCallExpression)
    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
    DefaultQuerySqlGenerator.AddLimitAndOffset()

    CreateQueryReader()

    Returns null.

    Declaration
    protected override IDataReaderEnvelope CreateQueryReader()
    Returns
    Type Description
    IDataReaderEnvelope

    Returns null.

    Overrides
    DefaultQuerySqlGenerator.CreateQueryReader()

    Implements

    ISqlExpressionVisitor
    Back to top KROS a.s.