Class Oracle12SqlOptimizer

Namespace

LinqToDB.DataProvider.Oracle

Assembly

linq2db.dll

public class Oracle12SqlOptimizer : Oracle11SqlOptimizer, ISqlOptimizer

Inheritance

object

BasicSqlOptimizer

Oracle11SqlOptimizer

Oracle12SqlOptimizer

Implements

ISqlOptimizer

Inherited Members

Oracle11SqlOptimizer.Finalize(MappingSchema, SqlStatement, DataOptions)

Oracle11SqlOptimizer.OracleLikeCharactersToEscape

Oracle11SqlOptimizer.LikeCharactersToEscape

Oracle11SqlOptimizer.IsParameterDependedElement(IQueryElement)

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

Oracle11SqlOptimizer.ConvertExpressionImpl(ISqlExpression, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>)

Oracle11SqlOptimizer.ReplaceTakeSkipWithRowNum(SqlStatement, bool)

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.OptimizeExpression(ISqlExpression, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext>)

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.LikeEscapeCharacter

BasicSqlOptimizer.LikeWildcardCharacter

BasicSqlOptimizer.LikePatternParameterSupport

BasicSqlOptimizer.LikeValueParameterSupport

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.ConvertSearchStringPredicate(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.FinalizeStatement(SqlStatement, EvaluationContext, DataOptions)

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

Oracle12SqlOptimizer(SqlProviderFlags)

public Oracle12SqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

Methods

ConvertFunction(SqlFunction)

protected override ISqlExpression ConvertFunction(SqlFunction func)

Parameters

func SqlFunction

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