Class SqlServerSqlOptimizer

Namespace

LinqToDB.Internal.DataProvider.SqlServer

Assembly

linq2db.dll

public class SqlServerSqlOptimizer : BasicSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

SqlServerSqlOptimizer

Implements

ISqlOptimizer

Derived

SqlServer2005SqlOptimizer

SqlServer2008SqlOptimizer

SqlServer2012SqlOptimizer

Inherited Members

BasicSqlOptimizer.CreateOptimizerVisitor(bool)

BasicSqlOptimizer.Finalize(MappingSchema, SqlStatement, DataOptions)

BasicSqlOptimizer.FinalizeInsert(SqlStatement)

BasicSqlOptimizer.IsCompatibleForUpdate(SelectQuery, SqlTable)

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

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

BasicSqlOptimizer.BasicCorrectUpdate(SqlUpdateStatement, DataOptions, bool)

BasicSqlOptimizer.FinalizeInsertOrUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.FinalizeSelect(SqlStatement)

BasicSqlOptimizer.CorrectUnionOrderBy(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, SqlTable, out SqlTableSource)

BasicSqlOptimizer.CloneTable(SqlTable, 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)

BasicSqlOptimizer.SqlProviderFlags

BasicSqlOptimizer.RequiresCastingParametersForSetOperations

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Constructors

SqlServerSqlOptimizer(SqlProviderFlags, SqlServerVersion)

protected SqlServerSqlOptimizer(SqlProviderFlags sqlProviderFlags, SqlServerVersion sqlVersion)

Parameters

sqlProviderFlags SqlProviderFlags

sqlVersion SqlServerVersion

Fields

SQLVersion

protected readonly SqlServerVersion SQLVersion

Field Value

SqlServerVersion

Methods

CreateConvertVisitor(bool)

public override SqlExpressionConvertVisitor CreateConvertVisitor(bool allowModify)

Parameters

allowModify bool

Returns

SqlExpressionConvertVisitor

FinalizeUpdate(SqlStatement, DataOptions, MappingSchema)

protected override SqlStatement FinalizeUpdate(SqlStatement statement, DataOptions dataOptions, MappingSchema mappingSchema)

Parameters

statement SqlStatement

dataOptions DataOptions

mappingSchema MappingSchema

Returns

SqlStatement

ReplaceSkipWithRowNumber(SqlStatement, MappingSchema)

protected SqlStatement ReplaceSkipWithRowNumber(SqlStatement statement, MappingSchema mappingSchema)

Parameters

statement SqlStatement

mappingSchema MappingSchema

Returns

SqlStatement

WrapRootTakeSkipOrderBy(SqlStatement)

protected SqlStatement WrapRootTakeSkipOrderBy(SqlStatement statement)

Parameters

statement SqlStatement

Returns

SqlStatement