Class MariaDBSqlOptimizer

Namespace

LinqToDB.Internal.DataProvider.MySql

Assembly

linq2db.dll

MariaDB differs from MySQL proper on window function requirements, so it gets its own convert visitor.

public class MariaDBSqlOptimizer : MySqlSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

MySqlSqlOptimizer

MariaDBSqlOptimizer

Implements

ISqlOptimizer

Inherited Members

MySqlSqlOptimizer.RequiresCastingNullValueForSetOperations

MySqlSqlOptimizer.CreateConvertVisitor(bool)

MySqlSqlOptimizer.TransformStatement(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>)

Remarks

A subclass rather than a version passed to MySqlSqlOptimizer: a remote data context builds its optimizer reflectively and accepts only a (SqlProviderFlags) or (SqlProviderFlags, DataOptions) constructor, so a version parameter would leave the type unconstructible over a LinqService connection.

Constructors

MariaDBSqlOptimizer(SqlProviderFlags)

public MariaDBSqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

Methods

CreateConvertVisitor(bool)

public override SqlExpressionConvertVisitor CreateConvertVisitor(bool allowModify)

Parameters

allowModify bool

Returns

SqlExpressionConvertVisitor