DefaultQuerySqlGenerator DefaultQuerySqlGenerator Class

Definition

The default query SQL generator.

public class DefaultQuerySqlGenerator : ThrowingExpressionVisitor, ISqlExpressionVisitor, IQuerySqlGenerator
Public Class DefaultQuerySqlGenerator
    Inherits ThrowingExpressionVisitor
    Implements ISqlExpressionVisitor, IQuerySqlGenerator
Inheritance
System.ObjectSystem.Object
DefaultQuerySqlGeneratorDefaultQuerySqlGenerator
Implements

Constructors

DefaultQuerySqlGenerator(IRelationalCommandBuilderFactory, ISqlGenerationHelper, IParameterNameGeneratorFactory, IRelationalTypeMapper, SelectExpression) DefaultQuerySqlGenerator(IRelationalCommandBuilderFactory, ISqlGenerationHelper, IParameterNameGeneratorFactory, IRelationalTypeMapper, SelectExpression)

Creates a new instance of DefaultQuerySqlGenerator.

Properties

ConcatOperator ConcatOperator

The default string concatenation operator SQL.

IsCacheable IsCacheable

Gets or sets a value indicating whether this SQL query is cacheable.

ParameterValues ParameterValues

Gets the parameter values.

SelectExpression SelectExpression

Gets the select expression.

Sql Sql

The generated SQL.

SqlGenerator SqlGenerator

Gets the SQL generation helper.

TypedFalseLiteral TypedFalseLiteral

The default false literal SQL.

TypedTrueLiteral TypedTrueLiteral

The default true literal SQL.

Methods

CreateUnhandledItemException<T>(T, String) CreateUnhandledItemException(Of T)(T, String)

Creates unhandled item exception.

CreateValueBufferFactory(IRelationalValueBufferFactoryFactory, DbDataReader) CreateValueBufferFactory(IRelationalValueBufferFactoryFactory, DbDataReader)

Creates a relational value buffer factory.

ExtractNonNullExpressionValues(IReadOnlyList<Expression>) ExtractNonNullExpressionValues(IReadOnlyList(Of Expression))

Extracts the non null expression values from a list of expressions.

GenerateBinaryOperator(ExpressionType) GenerateBinaryOperator(ExpressionType)

Generates SQL for a given binary operation type.

GenerateFromSql(String, Expression, IReadOnlyDictionary<String, Object>) GenerateFromSql(String, Expression, IReadOnlyDictionary(Of String, Object))

Generate SQL corresponding to a FromSql query.

GenerateLimitOffset(SelectExpression) GenerateLimitOffset(SelectExpression)

Generates the LIMIT OFFSET part of the SELECT statement,

GenerateOperator(Expression) GenerateOperator(Expression)

Generates an SQL operator for a given expression.

GenerateOrderBy(IReadOnlyList<Ordering>) GenerateOrderBy(IReadOnlyList(Of Ordering))

Generates the ORDER BY SQL.

GenerateSql(IReadOnlyDictionary<String, Object>) GenerateSql(IReadOnlyDictionary(Of String, Object))

Generates SQL for the given parameter values.

GenerateTop(SelectExpression) GenerateTop(SelectExpression)

Generates the TOP part of the SELECT statement,

InferTypeMappingFromColumn(Expression) InferTypeMappingFromColumn(Expression)

Infers a type mapping from a column expression.

ProcessInExpressionValues(IEnumerable<Expression>) ProcessInExpressionValues(IEnumerable(Of Expression))

Process the InExpression values.

TryGenerateBinaryOperator(ExpressionType, out String) TryGenerateBinaryOperator(ExpressionType, ByRef String)

Attempts to generate binary operator for a given expression type.

VisitAlias(AliasExpression) VisitAlias(AliasExpression)

Visits an AliasExpression.

VisitBinary(BinaryExpression) VisitBinary(BinaryExpression)

Visit a BinaryExpression.

VisitColumn(ColumnExpression) VisitColumn(ColumnExpression)

Visits a ColumnExpression.

VisitConditional(ConditionalExpression) VisitConditional(ConditionalExpression)

Visit a ConditionalExpression.

VisitConstant(ConstantExpression) VisitConstant(ConstantExpression)

Visits a ConstantExpression.

VisitCount(CountExpression) VisitCount(CountExpression)

Visit a CountExpression

VisitCrossJoin(CrossJoinExpression) VisitCrossJoin(CrossJoinExpression)

Visit a CrossJoin expression.

VisitExists(ExistsExpression) VisitExists(ExistsExpression)

Visit an ExistsExpression.

VisitExplicitCast(ExplicitCastExpression) VisitExplicitCast(ExplicitCastExpression)

Visit a SQL ExplicitCastExpression.

VisitFromSql(FromSqlExpression) VisitFromSql(FromSqlExpression)

Visit a FromSqlExpression.

VisitIn(InExpression) VisitIn(InExpression)

Visit an InExpression.

VisitInnerJoin(InnerJoinExpression) VisitInnerJoin(InnerJoinExpression)

Visit an InnerJoinExpression.

VisitIsNotNull(IsNullExpression) VisitIsNotNull(IsNullExpression)

Visits an IsNotNullExpression.

VisitIsNull(IsNullExpression) VisitIsNull(IsNullExpression)

Visits an IsNullExpression.

VisitLateralJoin(LateralJoinExpression) VisitLateralJoin(LateralJoinExpression)

Visit a LateralJoin expression.

VisitLeftOuterJoin(LeftOuterJoinExpression) VisitLeftOuterJoin(LeftOuterJoinExpression)

Visit an LeftOuterJoinExpression.

VisitLike(LikeExpression) VisitLike(LikeExpression)

Visit a LikeExpression.

VisitMax(MaxExpression) VisitMax(MaxExpression)

Visit a MaxExpression.

VisitMin(MinExpression) VisitMin(MinExpression)

Visit a MinExpression.

VisitNotIn(InExpression) VisitNotIn(InExpression)

Visit a negated InExpression.

VisitParameter(ParameterExpression) VisitParameter(ParameterExpression)

Visits a ParameterExpression.

VisitProjection(IReadOnlyList<Expression>) VisitProjection(IReadOnlyList(Of Expression))

Visit the projection.

VisitPropertyParameter(PropertyParameterExpression) VisitPropertyParameter(PropertyParameterExpression)

Visits a PropertyParameterExpression.

VisitSelect(SelectExpression) VisitSelect(SelectExpression)

Visit a top-level SelectExpression.

VisitSqlFunction(SqlFunctionExpression) VisitSqlFunction(SqlFunctionExpression)

Visits a SqlFunctionExpression.

VisitStringCompare(StringCompareExpression) VisitStringCompare(StringCompareExpression)

Visit a StringCompareExpression.

VisitSum(SumExpression) VisitSum(SumExpression)

Visit a SumExpression.

VisitTable(TableExpression) VisitTable(TableExpression)

Visit a TableExpression.

VisitUnary(UnaryExpression) VisitUnary(UnaryExpression)

Visits a UnaryExpression.