Class MySqlSqlOptimizer

Namespace

LinqToDB.Internal.DataProvider.MySql

Assembly

linq2db.dll

public class MySqlSqlOptimizer : BasicSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

MySqlSqlOptimizer

Implements

ISqlOptimizer

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.FinalizeUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.FinalizeInsertOrUpdate(SqlStatement, DataOptions, MappingSchema)

BasicSqlOptimizer.FinalizeSelect(SqlStatement)

BasicSqlOptimizer.CorrectUnionOrderBy(SqlStatement)

BasicSqlOptimizer.FixSetOperationValues(MappingSchema, SqlStatement)

BasicSqlOptimizer.FixEmptySelect(SqlStatement)

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

MySqlSqlOptimizer(SqlProviderFlags)

public MySqlSqlOptimizer(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