Class FirebirdSqlOptimizer

Namespace

LinqToDB.DataProvider.Firebird

Assembly

linq2db.dll

public class FirebirdSqlOptimizer : BasicSqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

FirebirdSqlOptimizer

Implements

ISqlOptimizer

Inherited Members

BasicSqlOptimizer.SqlProviderFlags

BasicSqlOptimizer.CorrectUnionOrderBy(SqlStatement)

BasicSqlOptimizer.FixSetOperationNulls(SqlStatement)

BasicSqlOptimizer.OptimizeUpdateSubqueries(SqlStatement, DataOptions)

BasicSqlOptimizer.FixEmptySelect(SqlStatement)

BasicSqlOptimizer.HasParameters(ISqlExpression)

BasicSqlOptimizer.ConvertCountSubQuery(SelectQuery)

BasicSqlOptimizer.CreateSqlValue(object, SqlBinaryExpression)

BasicSqlOptimizer.CreateSqlValue(object, DbDataType, params ISqlExpression[])

BasicSqlOptimizer.OptimizeFunction(SqlFunction, EvaluationContext)

BasicSqlOptimizer.OptimizePredicate(ISqlPredicate, EvaluationContext, DataOptions)

BasicSqlOptimizer.OptimizeRowExprExpr(SqlPredicate.ExprExpr, EvaluationContext)

BasicSqlOptimizer.OptimizeRowInList(SqlPredicate.InList)

BasicSqlOptimizer.RowIsNullFallback(SqlRow, bool)

BasicSqlOptimizer.RowComparisonFallback(SqlPredicate.Operator, SqlRow, SqlRow, EvaluationContext)

BasicSqlOptimizer.ConvertBetweenPredicate(SqlPredicate.Between)

BasicSqlOptimizer.OptimizeQueryElement(ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>, IQueryElement)

BasicSqlOptimizer.OptimizeBinaryExpression(SqlBinaryExpression, EvaluationContext)

BasicSqlOptimizer.ConvertElement(MappingSchema, DataOptions, IQueryElement, OptimizationContext)

BasicSqlOptimizer.OptimizeElement(MappingSchema, DataOptions, IQueryElement, OptimizationContext, bool)

BasicSqlOptimizer.CanCompareSearchConditions

BasicSqlOptimizer.ConvertPredicateImpl(ISqlPredicate, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>)

BasicSqlOptimizer.LikeEscapeCharacter

BasicSqlOptimizer.LikeWildcardCharacter

BasicSqlOptimizer.LikePatternParameterSupport

BasicSqlOptimizer.LikeIsEscapeSupported

BasicSqlOptimizer.StandardLikeCharactersToEscape

BasicSqlOptimizer.EscapeLikeCharacters(string, string)

BasicSqlOptimizer.GenerateEscapeReplacement(ISqlExpression, ISqlExpression)

BasicSqlOptimizer.EscapeLikePattern(string)

BasicSqlOptimizer.EscapeLikeCharacters(ISqlExpression, ref ISqlExpression)

BasicSqlOptimizer.ConvertLikePredicate(MappingSchema, SqlPredicate.Like, EvaluationContext)

BasicSqlOptimizer.ConvertSearchStringPredicateViaLike(SqlPredicate.SearchString, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>)

BasicSqlOptimizer.ConvertInListPredicate(MappingSchema, SqlPredicate.InList, EvaluationContext)

BasicSqlOptimizer.ConvertCoalesceToBinaryFunc(SqlFunction, string, bool)

BasicSqlOptimizer.GetMaxLength(SqlDataType)

BasicSqlOptimizer.GetMaxPrecision(SqlDataType)

BasicSqlOptimizer.GetMaxScale(SqlDataType)

BasicSqlOptimizer.GetMaxDisplaySize(SqlDataType)

BasicSqlOptimizer.ConvertConversion(SqlFunction)

BasicSqlOptimizer.AlternativeConvertToBoolean(SqlFunction, DataOptions, int)

BasicSqlOptimizer.ConvertBooleanExprToCase(ISqlExpression)

BasicSqlOptimizer.IsDateDataType(ISqlExpression, string)

BasicSqlOptimizer.IsSmallDateTimeType(ISqlExpression, string)

BasicSqlOptimizer.IsDateTime2Type(ISqlExpression, string)

BasicSqlOptimizer.IsDateTimeType(ISqlExpression, string)

BasicSqlOptimizer.IsDateDataOffsetType(ISqlExpression)

BasicSqlOptimizer.IsTimeDataType(ISqlExpression)

BasicSqlOptimizer.FloorBeforeConvert(SqlFunction)

BasicSqlOptimizer.GetAlternativeDelete(SqlDeleteStatement, DataOptions)

BasicSqlOptimizer.GetMainTableSource(SelectQuery)

BasicSqlOptimizer.IsAggregationFunction(IQueryElement)

BasicSqlOptimizer.NeedsEnvelopingForUpdate(SelectQuery)

BasicSqlOptimizer.GetAlternativeUpdate(SqlUpdateStatement, DataOptions)

BasicSqlOptimizer.FindUpdateTable(SelectQuery, SqlTable)

BasicSqlOptimizer.GetAlternativeUpdatePostgreSqlite(SqlUpdateStatement, DataOptions)

BasicSqlOptimizer.CorrectUpdateTable(SqlUpdateStatement)

BasicSqlOptimizer.CheckAliases(SqlStatement, int)

BasicSqlOptimizer.Add(ISqlExpression, ISqlExpression, Type)

BasicSqlOptimizer.Add<T>(ISqlExpression, ISqlExpression)

BasicSqlOptimizer.Add(ISqlExpression, int)

BasicSqlOptimizer.Inc(ISqlExpression)

BasicSqlOptimizer.Sub(ISqlExpression, ISqlExpression, Type)

BasicSqlOptimizer.Sub<T>(ISqlExpression, ISqlExpression)

BasicSqlOptimizer.Sub(ISqlExpression, int)

BasicSqlOptimizer.Dec(ISqlExpression)

BasicSqlOptimizer.Mul(ISqlExpression, ISqlExpression, Type)

BasicSqlOptimizer.Mul<T>(ISqlExpression, ISqlExpression)

BasicSqlOptimizer.Mul(ISqlExpression, int)

BasicSqlOptimizer.Div(ISqlExpression, ISqlExpression, Type)

BasicSqlOptimizer.Div<T>(ISqlExpression, ISqlExpression)

BasicSqlOptimizer.Div(ISqlExpression, int)

BasicSqlOptimizer.OptimizeJoins(SqlStatement)

BasicSqlOptimizer.IsParameterDependedQuery(SelectQuery)

BasicSqlOptimizer.IsParameterDependent(SqlStatement)

BasicSqlOptimizer.OptimizeAggregates(SqlStatement)

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

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

BasicSqlOptimizer.ReplaceTakeSkipWithRowNumber(SqlStatement, bool, bool)

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

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

BasicSqlOptimizer.TryConvertToValue(ISqlExpression, EvaluationContext)

BasicSqlOptimizer.IsBooleanParameter(ISqlExpression, int, int)

BasicSqlOptimizer.ConvertFunctionParameters(SqlFunction, bool)

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

FirebirdSqlOptimizer(SqlProviderFlags)

public FirebirdSqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

Fields

LikeFirebirdEscapeSymbols

protected static string[] LikeFirebirdEscapeSymbols

Field Value

string[]

Properties

LikeCharactersToEscape

Characters with special meaning in LIKE predicate (defined by LikeCharactersToEscape) that should be escaped to be used as matched character. Default: ["%", "_", "?", "*", "#", "[", "]"].

public override string[] LikeCharactersToEscape { get; }

Property Value

string[]

LikeValueParameterSupport

public override bool LikeValueParameterSupport { get; }

Property Value

bool

Methods

ConvertExpressionImpl(ISqlExpression, ConvertVisitor<RunOptimizationContext>)

public override ISqlExpression ConvertExpressionImpl(ISqlExpression expression, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext> visitor)

Parameters

expression ISqlExpression

visitor ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>

Returns

ISqlExpression

ConvertFunction(SqlFunction)

protected override ISqlExpression ConvertFunction(SqlFunction func)

Parameters

func SqlFunction

Returns

ISqlExpression

ConvertSearchStringPredicate(SearchString, ConvertVisitor<RunOptimizationContext>)

public override ISqlPredicate ConvertSearchStringPredicate(SqlPredicate.SearchString predicate, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext> visitor)

Parameters

predicate SqlPredicate.SearchString

visitor ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>

Returns

ISqlPredicate

Finalize(MappingSchema, SqlStatement, DataOptions)

Finalizes query.

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

Parameters

mappingSchema MappingSchema

statement SqlStatement

dataOptions DataOptions

Returns

SqlStatement

Query which is ready for optimization.

FinalizeStatement(SqlStatement, EvaluationContext, DataOptions)

public override SqlStatement FinalizeStatement(SqlStatement statement, EvaluationContext context, DataOptions dataOptions)

Parameters

statement SqlStatement

context EvaluationContext

dataOptions DataOptions

Returns

SqlStatement

IsParameterDependedElement(IQueryElement)

public override bool IsParameterDependedElement(IQueryElement element)

Parameters

element IQueryElement

Returns

bool

OptimizeExpression(ISqlExpression, ConvertVisitor<RunOptimizationContext>)

public override ISqlExpression OptimizeExpression(ISqlExpression expression, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext> convertVisitor)

Parameters

expression ISqlExpression

convertVisitor ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>

Returns

ISqlExpression

TransformStatement(SqlStatement, DataOptions)

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

public override SqlStatement TransformStatement(SqlStatement statement, DataOptions dataOptions)

Parameters

statement SqlStatement

dataOptions DataOptions

Returns

SqlStatement