Class SqlServer2012SqlOptimizer

Namespace

LinqToDB.Internal.DataProvider.SqlServer

Assembly

linq2db.dll

public class SqlServer2012SqlOptimizer : SqlServerSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

SqlServerSqlOptimizer

SqlServer2012SqlOptimizer

Implements

ISqlOptimizer

Derived

SqlServer2014SqlOptimizer

SqlServer2016SqlOptimizer

SqlServer2017SqlOptimizer

SqlServer2019SqlOptimizer

Inherited Members

SqlServerSqlOptimizer.SQLVersion

SqlServerSqlOptimizer.CreateConvertVisitor(bool)

SqlServerSqlOptimizer.ReplaceSkipWithRowNumber(SqlStatement, MappingSchema)

SqlServerSqlOptimizer.WrapRootTakeSkipOrderBy(SqlStatement)

SqlServerSqlOptimizer.FinalizeUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.SqlProviderFlags

BasicSqlOptimizer.RequiresCastingParametersForSetOperations

BasicSqlOptimizer.RequiresCastingNullValueForSetOperations

BasicSqlOptimizer.CreateOptimizerVisitor(bool)

BasicSqlOptimizer.CreateConvertVisitor(bool)

BasicSqlOptimizer.Finalize(MappingSchema, SqlStatement, DataOptions)

BasicSqlOptimizer.FinalizeInsert(SqlStatement)

BasicSqlOptimizer.IsCompatibleForUpdate(SelectQuery, ISqlNamedTable)

BasicSqlOptimizer.ApplyUpdateTableComparison(SqlSearchCondition, SqlUpdateClause, ISqlNamedTable, DataOptions)

BasicSqlOptimizer.ApplyUpdateTableComparison(SelectQuery, SqlUpdateClause, ISqlNamedTable, DataOptions)

BasicSqlOptimizer.BasicCorrectUpdate(SqlUpdateStatement, DataOptions, bool)

BasicSqlOptimizer.FinalizeUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.FinalizeInsertOrUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.FinalizeSelect(SqlStatement)

BasicSqlOptimizer.FixSetOperationValues(MappingSchema, SqlStatement)

BasicSqlOptimizer.FixEmptySelect(SqlStatement)

BasicSqlOptimizer.TransformStatement(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.CorrectOutputTables(SqlStatement)

BasicSqlOptimizer.FinalizeCte(SqlStatement)

BasicSqlOptimizer.HasParameters(ISqlExpression)

BasicSqlOptimizer.GetAlternativeDelete(SqlDeleteStatement)

BasicSqlOptimizer.NeedsEnvelopingForUpdate(SelectQuery)

BasicSqlOptimizer.RemoveUpdateTableIfPossible(SelectQuery, ISqlNamedTable, out SqlTableSource)

BasicSqlOptimizer.RemoveUpdateTableIfPossible(SelectQuery, ISqlNamedTable, bool, out SqlTableSource)

BasicSqlOptimizer.CloneTable(ISqlNamedTable, out Dictionary<IQueryElement, IQueryElement>)

BasicSqlOptimizer.RemapCloned<TElement>(TElement, Dictionary<IQueryElement, IQueryElement>, Dictionary<IQueryElement, IQueryElement>, bool)

BasicSqlOptimizer.GetAlternativeUpdate(SqlUpdateStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.CorrectSetters(List<SqlSetExpression>, SelectQuery)

BasicSqlOptimizer.CorrectUpdateSetters(SqlUpdateStatement)

BasicSqlOptimizer.DetachUpdateTableFromUpdateQuery(SqlUpdateStatement, DataOptions, bool, bool, out SqlTableSource)

BasicSqlOptimizer.GetAlternativeUpdatePostgreSqlite(SqlUpdateStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.CorrectUpdateTable(SqlUpdateStatement, bool, DataOptions, MappingSchema)

BasicSqlOptimizer.IsParameterDependedQuery(SelectQuery)

BasicSqlOptimizer.IsParameterDependedElement(NullabilityContext, IQueryElement, DataOptions, MappingSchema)

BasicSqlOptimizer.IsParameterDependent(NullabilityContext, MappingSchema, SqlStatement, DataOptions)

BasicSqlOptimizer.FinalizeStatement(SqlStatement, EvaluationContext, DataOptions, MappingSchema)

BasicSqlOptimizer.ConvertSkipTake(NullabilityContext, MappingSchema, DataOptions, SelectQuery, OptimizationContext, out ISqlExpression, out ISqlExpression)

BasicSqlOptimizer.SeparateDistinctFromPagination(SqlStatement, Func<SelectQuery, bool>)

BasicSqlOptimizer.ReplaceTakeSkipWithRowNumber<TContext>(TContext, SqlStatement, MappingSchema, Func<TContext, SelectQuery, bool>, bool)

BasicSqlOptimizer.OptimizeQueries(IQueryElement, IQueryElement, DataOptions, MappingSchema, EvaluationContext)

BasicSqlOptimizer.CorrectMultiTableQueries(SqlStatement)

BasicSqlOptimizer.CreateSqlExpressionFactory(MappingSchema, DataOptions)

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

SqlServer2012SqlOptimizer(SqlProviderFlags)

public SqlServer2012SqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

SqlServer2012SqlOptimizer(SqlProviderFlags, SqlServerVersion)

protected SqlServer2012SqlOptimizer(SqlProviderFlags sqlProviderFlags, SqlServerVersion version)

Parameters

sqlProviderFlags SqlProviderFlags

version SqlServerVersion

Methods

AddOrderByForSkip(SqlStatement)

Adds an ORDER BY clause to queries using OFFSET/FETCH, if none exists

protected SqlStatement AddOrderByForSkip(SqlStatement statement)

Parameters

statement SqlStatement

Returns

SqlStatement

CreateConvertVisitor(bool)

public override SqlExpressionConvertVisitor CreateConvertVisitor(bool allowModify)

Parameters

allowModify bool

Returns

SqlExpressionConvertVisitor

TransformStatement(SqlStatement, DataOptions, MappingSchema)

Used for correcting statement and should return new statement if changes were made.

public override SqlStatement TransformStatement(SqlStatement statement, DataOptions dataOptions, MappingSchema mappingSchema)

Parameters

statement SqlStatement

dataOptions DataOptions

mappingSchema MappingSchema

Returns

SqlStatement