Table of Contents

Class Oracle11SqlOptimizer

Namespace
LinqToDB.DataProvider.Oracle
Assembly
linq2db.dll
public class Oracle11SqlOptimizer : BasicSqlOptimizer, ISqlOptimizer
Inheritance
Oracle11SqlOptimizer
Implements
Derived
Inherited Members
Extension Methods

Constructors

Oracle11SqlOptimizer(SqlProviderFlags) 

public Oracle11SqlOptimizer(SqlProviderFlags sqlProviderFlags)

Parameters

sqlProviderFlags SqlProviderFlags

Fields

OracleLikeCharactersToEscape 

protected static string[] OracleLikeCharactersToEscape

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[]

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

ConvertPredicateImpl(ISqlPredicate, ConvertVisitor<RunOptimizationContext>) 

public override ISqlPredicate ConvertPredicateImpl(ISqlPredicate predicate, ConvertVisitor<BasicSqlOptimizer.RunOptimizationContext> visitor)

Parameters

predicate ISqlPredicate
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.

IsParameterDependedElement(IQueryElement) 

public override bool IsParameterDependedElement(IQueryElement element)

Parameters

element IQueryElement

Returns

bool

ReplaceTakeSkipWithRowNum(SqlStatement, bool)

Replaces Take/Skip by ROWNUM usage. See 'Pagination with ROWNUM' for more information.

protected SqlStatement ReplaceTakeSkipWithRowNum(SqlStatement statement, bool onlySubqueries)

Parameters

statement SqlStatement

Statement which may contain take/skip modifiers.

onlySubqueries bool

Indicates when transformation needed only for subqueries.

Returns

SqlStatement

The same statement or modified statement when optimization has been performed.

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