Class SqlServer2005SqlOptimizer

Namespace

LinqToDB.Internal.DataProvider.SqlServer

Assembly

linq2db.dll

public class SqlServer2005SqlOptimizer : SqlServerSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

SqlServerSqlOptimizer

SqlServer2005SqlOptimizer

Implements

ISqlOptimizer

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

SqlServer2005SqlOptimizer(SqlProviderFlags)

public SqlServer2005SqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

Methods

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