Table of Contents

Class OracleSqlExpressionConvertVisitor

Namespace
LinqToDB.Internal.DataProvider.Oracle
Assembly
linq2db.dll
public class OracleSqlExpressionConvertVisitor : SqlExpressionConvertVisitor
Inheritance
object
OracleSqlExpressionConvertVisitor
Derived
Inherited Members
Extension Methods

Constructors

OracleSqlExpressionConvertVisitor(bool) 

public OracleSqlExpressionConvertVisitor(bool allowModify)

Parameters

allowModify bool

Fields

OracleLikeCharactersToEscape 

protected static readonly string[] OracleLikeCharactersToEscape

Field Value

string[]

Properties

ConcatRequiresExplicitStringCast

When true (default), ConvertConcat(SqlConcatExpression) wraps every non-string operand in an explicit CAST(... AS VARCHAR(N)) before adding it to the concat chain. Required for providers whose concat operator is + (SQL Server pre-2025, SqlCe, Sybase ASE, Access) — SQL-standard data-type precedence would otherwise try to coerce string operands to the non-string side's type. Providers whose final concat operator is || (PostgreSQL / Oracle / SQLite / SAP HANA / DuckDB / Firebird / DB2 / Informix / SQL Server 2025+) or CONCAT(...) function (MySQL / ClickHouse) auto-coerce non-string operands and override this to false for cleaner SQL.

protected override bool ConcatRequiresExplicitStringCast { get; }

Property Value

bool

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

ConvertCoalesce(SqlCoalesceExpression) 

public override ISqlExpression ConvertCoalesce(SqlCoalesceExpression element)

Parameters

element SqlCoalesceExpression

Returns

ISqlExpression

ConvertConcat(SqlConcatExpression) 

public override ISqlExpression ConvertConcat(SqlConcatExpression element)

Parameters

element SqlConcatExpression

Returns

ISqlExpression

ConvertConversion(SqlCastExpression)

Implements SqlCastExpression conversion.

protected override ISqlExpression ConvertConversion(SqlCastExpression cast)

Parameters

cast SqlCastExpression

Returns

ISqlExpression

ConvertExprExprPredicate(ExprExpr) 

public override IQueryElement ConvertExprExprPredicate(SqlPredicate.ExprExpr predicate)

Parameters

predicate SqlPredicate.ExprExpr

Returns

IQueryElement

ConvertSqlBinaryExpression(SqlBinaryExpression) 

public override IQueryElement ConvertSqlBinaryExpression(SqlBinaryExpression element)

Parameters

element SqlBinaryExpression

Returns

IQueryElement

ConvertSqlCaseExpression(SqlCaseExpression) 

protected override ISqlExpression ConvertSqlCaseExpression(SqlCaseExpression element)

Parameters

element SqlCaseExpression

Returns

ISqlExpression

ConvertSqlCondition(SqlConditionExpression) 

protected override ISqlExpression ConvertSqlCondition(SqlConditionExpression element)

Parameters

element SqlConditionExpression

Returns

ISqlExpression

ConvertSqlExpression(SqlExpression) 

public override ISqlExpression ConvertSqlExpression(SqlExpression element)

Parameters

element SqlExpression

Returns

ISqlExpression

ConvertSqlFunction(SqlFunction) 

public override ISqlExpression ConvertSqlFunction(SqlFunction func)

Parameters

func SqlFunction

Returns

ISqlExpression

ConvertSqlUnaryExpression(SqlUnaryExpression) 

public override ISqlExpression ConvertSqlUnaryExpression(SqlUnaryExpression element)

Parameters

element SqlUnaryExpression

Returns

ISqlExpression

VisitSqlValuesTable(SqlValuesTable) 

protected override IQueryElement VisitSqlValuesTable(SqlValuesTable element)

Parameters

element SqlValuesTable

Returns

IQueryElement