Class SqlExpressionFactoryExtensions

Namespace

LinqToDB.Internal.DataProvider.Translation

Assembly

linq2db.dll

public static class SqlExpressionFactoryExtensions

Inheritance

object

SqlExpressionFactoryExtensions

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

Add(ISqlExpressionFactory, DbDataType, ISqlExpression, ISqlExpression)

public static ISqlExpression Add(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

Binary(ISqlExpressionFactory, DbDataType, ISqlExpression, string, ISqlExpression)

public static ISqlExpression Binary(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, string operation, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

operation string

y ISqlExpression

Returns

ISqlExpression

Cast(ISqlExpressionFactory, ISqlExpression, DbDataType, SqlDataType?, bool)

public static ISqlExpression Cast(this ISqlExpressionFactory factory, ISqlExpression expression, DbDataType toDbDataType, SqlDataType? fromType, bool isMandatory = false)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

toDbDataType DbDataType

fromType SqlDataType

isMandatory bool

Returns

ISqlExpression

Cast(ISqlExpressionFactory, ISqlExpression, DbDataType, bool)

public static ISqlExpression Cast(this ISqlExpressionFactory factory, ISqlExpression expression, DbDataType toDbDataType, bool isMandatory = false)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

toDbDataType DbDataType

isMandatory bool

Returns

ISqlExpression

Coalesce(ISqlExpressionFactory, params ISqlExpression[])

public static ISqlExpression Coalesce(this ISqlExpressionFactory factory, params ISqlExpression[] expressions)

Parameters

factory ISqlExpressionFactory

expressions ISqlExpression[]

Returns

ISqlExpression

Concat(ISqlExpressionFactory, DbDataType, ISqlExpression, ISqlExpression)

public static ISqlExpression Concat(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

Concat(ISqlExpressionFactory, DbDataType, ISqlExpression, string)

public static ISqlExpression Concat(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, string value)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

value string

Returns

ISqlExpression

Concat(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlExpression Concat(this ISqlExpressionFactory factory, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

Concat(ISqlExpressionFactory, ISqlExpression, string)

public static ISqlExpression Concat(this ISqlExpressionFactory factory, ISqlExpression x, string value)

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value string

Returns

ISqlExpression

Concat(ISqlExpressionFactory, params ISqlExpression[])

public static ISqlExpression Concat(this ISqlExpressionFactory factory, params ISqlExpression[] expressions)

Parameters

factory ISqlExpressionFactory

expressions ISqlExpression[]

Returns

ISqlExpression

Condition(ISqlExpressionFactory, ISqlPredicate, ISqlExpression, ISqlExpression)

public static ISqlExpression Condition(this ISqlExpressionFactory factory, ISqlPredicate condition, ISqlExpression trueExpression, ISqlExpression falseExpression)

Parameters

factory ISqlExpressionFactory

condition ISqlPredicate

trueExpression ISqlExpression

falseExpression ISqlExpression

Returns

ISqlExpression

Decrement(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression Decrement(this ISqlExpressionFactory factory, ISqlExpression x)

Parameters

factory ISqlExpressionFactory

x ISqlExpression

Returns

ISqlExpression

Decrement<T>(ISqlExpressionFactory, ISqlExpression, T)

public static ISqlExpression Decrement<T>(this ISqlExpressionFactory factory, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

Div(ISqlExpressionFactory, DbDataType, ISqlExpression, ISqlExpression)

public static ISqlExpression Div(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

Div<T>(ISqlExpressionFactory, DbDataType, ISqlExpression, T)

public static ISqlExpression Div<T>(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

EnsureType(ISqlExpressionFactory, ISqlExpression, DbDataType)

public static ISqlExpression EnsureType(this ISqlExpressionFactory factory, ISqlExpression expression, DbDataType dbDataType)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

dbDataType DbDataType

Returns

ISqlExpression

Equal(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate Equal(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

Equal(ISqlExpressionFactory, ISqlExpression, ISqlExpression, bool?)

public static ISqlPredicate Equal(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2, bool? unknownValue)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

unknownValue bool?

Returns

ISqlPredicate

ExprPredicate(ISqlExpressionFactory, ISqlExpression)

public static ISqlPredicate ExprPredicate(this ISqlExpressionFactory factory, ISqlExpression expression)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

Returns

ISqlPredicate

Expression(ISqlExpressionFactory, DbDataType, int, string, params ISqlExpression[])

public static ISqlExpression Expression(this ISqlExpressionFactory factory, DbDataType dataType, int precedence, string expr, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

precedence int

expr string

parameters ISqlExpression[]

Returns

ISqlExpression

Expression(ISqlExpressionFactory, DbDataType, int, string, bool?, params ISqlExpression[])

public static ISqlExpression Expression(this ISqlExpressionFactory factory, DbDataType dataType, int precedence, string expr, bool? canBeNull, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

precedence int

expr string

canBeNull bool?

parameters ISqlExpression[]

Returns

ISqlExpression

Expression(ISqlExpressionFactory, DbDataType, string, params ISqlExpression[])

public static ISqlExpression Expression(this ISqlExpressionFactory factory, DbDataType dataType, string expr, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

expr string

parameters ISqlExpression[]

Returns

ISqlExpression

Expression(ISqlExpressionFactory, DbDataType, string, int, params ISqlExpression[])

public static ISqlExpression Expression(this ISqlExpressionFactory factory, DbDataType dataType, string expr, int precedence, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

expr string

precedence int

parameters ISqlExpression[]

Returns

ISqlExpression

Fragment(ISqlExpressionFactory, string, params ISqlExpression[])

public static ISqlExpression Fragment(this ISqlExpressionFactory factory, string fragmentText, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

fragmentText string

parameters ISqlExpression[]

Returns

ISqlExpression

Fragment(ISqlExpressionFactory, string, int, params ISqlExpression[])

public static ISqlExpression Fragment(this ISqlExpressionFactory factory, string fragmentText, int precedence, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

fragmentText string

precedence int

parameters ISqlExpression[]

Returns

ISqlExpression

Function(ISqlExpressionFactory, DbDataType, string, params ISqlExpression[])

public static ISqlExpression Function(this ISqlExpressionFactory factory, DbDataType type, string functionName, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

type DbDataType

functionName string

parameters ISqlExpression[]

Returns

ISqlExpression

Function(ISqlExpressionFactory, DbDataType, string, ParametersNullabilityType, params ISqlExpression[])

public static ISqlExpression Function(this ISqlExpressionFactory factory, DbDataType dataType, string functionName, ParametersNullabilityType parametersNullability, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

functionName string

parametersNullability ParametersNullabilityType

parameters ISqlExpression[]

Returns

ISqlExpression

Function(ISqlExpressionFactory, DbDataType, string, SqlFunctionArgument[], bool[], bool?, IEnumerable<SqlWindowOrderItem>?, IEnumerable<ISqlExpression>?, IEnumerable<SqlWindowOrderItem>?, SqlFrameClause?, SqlSearchCondition?, bool, bool)

public static ISqlExpression Function(this ISqlExpressionFactory factory, DbDataType dataType, string functionName, SqlFunctionArgument[] arguments, bool[] argumentsNullability, bool? canBeNull = null, IEnumerable<SqlWindowOrderItem>? withinGroup = null, IEnumerable<ISqlExpression>? partitionBy = null, IEnumerable<SqlWindowOrderItem>? orderBy = null, SqlFrameClause? frameClause = null, SqlSearchCondition? filter = null, bool isAggregate = false, bool canBeAffectedByOrderBy = false)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

functionName string

arguments SqlFunctionArgument[]

argumentsNullability bool[]

canBeNull bool?

withinGroup IEnumerable<SqlWindowOrderItem>

partitionBy IEnumerable<ISqlExpression>

orderBy IEnumerable<SqlWindowOrderItem>

frameClause SqlFrameClause

filter SqlSearchCondition

isAggregate bool

canBeAffectedByOrderBy bool

Returns

ISqlExpression

Greater(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate Greater(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

GreaterOrEqual(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate GreaterOrEqual(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

Increment(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression Increment(this ISqlExpressionFactory factory, ISqlExpression x)

Parameters

factory ISqlExpressionFactory

x ISqlExpression

Returns

ISqlExpression

Increment<T>(ISqlExpressionFactory, ISqlExpression, T)

public static ISqlExpression Increment<T>(this ISqlExpressionFactory factory, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

IsNull(ISqlExpressionFactory, ISqlExpression, bool)

public static ISqlPredicate IsNull(this ISqlExpressionFactory factory, ISqlExpression expr, bool isNot = false)

Parameters

factory ISqlExpressionFactory

expr ISqlExpression

isNot bool

Returns

ISqlPredicate

IsNullPredicate(ISqlExpressionFactory, ISqlExpression, bool)

public static ISqlPredicate IsNullPredicate(this ISqlExpressionFactory factory, ISqlExpression expression, bool isNot = false)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

isNot bool

Returns

ISqlPredicate

Length(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression Length(this ISqlExpressionFactory factory, ISqlExpression expression)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

Returns

ISqlExpression

Less(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate Less(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

LessOrEqual(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate LessOrEqual(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

LikePredicate(ISqlExpressionFactory, ISqlExpression, bool, ISqlExpression, ISqlExpression?, string?)

public static SqlPredicate.Like LikePredicate(this ISqlExpressionFactory factory, ISqlExpression value, bool isNull, ISqlExpression template, ISqlExpression? escape = null, string? functionName = null)

Parameters

factory ISqlExpressionFactory

value ISqlExpression

isNull bool

template ISqlExpression

escape ISqlExpression

functionName string

Returns

SqlPredicate.Like

Mod(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlExpression Mod(this ISqlExpressionFactory factory, ISqlExpression x, ISqlExpression value)

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value ISqlExpression

Returns

ISqlExpression

Mod<T>(ISqlExpressionFactory, ISqlExpression, T)

public static ISqlExpression Mod<T>(this ISqlExpressionFactory factory, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

Multiply(ISqlExpressionFactory, DbDataType, ISqlExpression, ISqlExpression)

public static ISqlExpression Multiply(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

Multiply<T>(ISqlExpressionFactory, DbDataType, ISqlExpression, T)

public static ISqlExpression Multiply<T>(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

Multiply<T>(ISqlExpressionFactory, ISqlExpression, T)

public static ISqlExpression Multiply<T>(this ISqlExpressionFactory factory, ISqlExpression x, T value) where T : struct

Parameters

factory ISqlExpressionFactory

x ISqlExpression

value T

Returns

ISqlExpression

Type Parameters

T

Negate(ISqlExpressionFactory, DbDataType, ISqlExpression)

public static ISqlExpression Negate(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression v)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

v ISqlExpression

Returns

ISqlExpression

NonPureExpression(ISqlExpressionFactory, DbDataType, string, params ISqlExpression[])

public static ISqlExpression NonPureExpression(this ISqlExpressionFactory factory, DbDataType dataType, string expr, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

expr string

parameters ISqlExpression[]

Returns

ISqlExpression

NonPureFunction(ISqlExpressionFactory, DbDataType, string, params ISqlExpression[])

public static ISqlExpression NonPureFunction(this ISqlExpressionFactory factory, DbDataType dataType, string functionName, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

functionName string

parameters ISqlExpression[]

Returns

ISqlExpression

NotEqual(ISqlExpressionFactory, ISqlExpression, ISqlExpression)

public static ISqlPredicate NotEqual(this ISqlExpressionFactory factory, ISqlExpression expr1, ISqlExpression expr2)

Parameters

factory ISqlExpressionFactory

expr1 ISqlExpression

expr2 ISqlExpression

Returns

ISqlPredicate

NotNull(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression NotNull(this ISqlExpressionFactory factory, ISqlExpression expression)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

Returns

ISqlExpression

NotNullExpression(ISqlExpressionFactory, DbDataType, int, string, params ISqlExpression[])

public static ISqlExpression NotNullExpression(this ISqlExpressionFactory factory, DbDataType dataType, int precedence, string expr, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

precedence int

expr string

parameters ISqlExpression[]

Returns

ISqlExpression

NotNullExpression(ISqlExpressionFactory, DbDataType, string, params ISqlExpression[])

public static ISqlExpression NotNullExpression(this ISqlExpressionFactory factory, DbDataType dataType, string expr, params ISqlExpression[] parameters)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

expr string

parameters ISqlExpression[]

Returns

ISqlExpression

Null(ISqlExpressionFactory, DbDataType)

public static ISqlExpression Null(this ISqlExpressionFactory factory, DbDataType dataType)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

Returns

ISqlExpression

NullValue(ISqlExpressionFactory, DbDataType)

public static ISqlExpression NullValue(this ISqlExpressionFactory factory, DbDataType dataType)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

Returns

ISqlExpression

Replace(ISqlExpressionFactory, ISqlExpression, ISqlExpression, ISqlExpression)

public static ISqlExpression Replace(this ISqlExpressionFactory factory, ISqlExpression expression, ISqlExpression oldSubString, ISqlExpression newSubstring)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

oldSubString ISqlExpression

newSubstring ISqlExpression

Returns

ISqlExpression

SearchCondition(ISqlExpressionFactory, bool)

public static SqlSearchCondition SearchCondition(this ISqlExpressionFactory factory, bool isOr = false)

Parameters

factory ISqlExpressionFactory

isOr bool

Returns

SqlSearchCondition

SqlDataType(ISqlExpressionFactory, DataType)

public static SqlDataType SqlDataType(this ISqlExpressionFactory factory, DataType dataType)

Parameters

factory ISqlExpressionFactory

dataType DataType

Returns

SqlDataType

SqlDataType(ISqlExpressionFactory, DbDataType)

public static SqlDataType SqlDataType(this ISqlExpressionFactory factory, DbDataType type)

Parameters

factory ISqlExpressionFactory

type DbDataType

Returns

SqlDataType

Sub(ISqlExpressionFactory, DbDataType, ISqlExpression, ISqlExpression)

public static ISqlExpression Sub(this ISqlExpressionFactory factory, DbDataType dbDataType, ISqlExpression x, ISqlExpression y)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

x ISqlExpression

y ISqlExpression

Returns

ISqlExpression

ToLower(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression ToLower(this ISqlExpressionFactory factory, ISqlExpression expression)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

Returns

ISqlExpression

ToUpper(ISqlExpressionFactory, ISqlExpression)

public static ISqlExpression ToUpper(this ISqlExpressionFactory factory, ISqlExpression expression)

Parameters

factory ISqlExpressionFactory

expression ISqlExpression

Returns

ISqlExpression

TypeExpression(ISqlExpressionFactory, DbDataType)

public static ISqlExpression TypeExpression(this ISqlExpressionFactory factory, DbDataType dbDataType)

Parameters

factory ISqlExpressionFactory

dbDataType DbDataType

Returns

ISqlExpression

Value<T>(ISqlExpressionFactory, DbDataType, T)

public static ISqlExpression Value<T>(this ISqlExpressionFactory factory, DbDataType dataType, T value)

Parameters

factory ISqlExpressionFactory

dataType DbDataType

value T

Returns

ISqlExpression

Type Parameters

T

Value<T>(ISqlExpressionFactory, T)

public static ISqlExpression Value<T>(this ISqlExpressionFactory factory, T value)

Parameters

factory ISqlExpressionFactory

value T

Returns

ISqlExpression

Type Parameters

T