Table of Contents

Class Expressions

Namespace
LinqToDB.Linq
Assembly
linq2db.dll
public static class Expressions
Inheritance
Expressions

Methods

AccessInt<T>(T) 

[CLSCompliant(false)]
[Sql.Function("Int", new int[] { 0 })]
public static T AccessInt<T>(T value)

Parameters

value T

Returns

T

Type Parameters

T

AccessRound<T>(T, int?) 

[CLSCompliant(false)]
[Sql.Function("Round", new int[] { 0, 1 })]
public static T AccessRound<T>(T value, int? precision)

Parameters

value T
precision int?

Returns

T

Type Parameters

T

AltStuff(string?, int?, int?, string?) 

[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static string? AltStuff(string? str, int? startLocation, int? length, string? value)

Parameters

str string
startLocation int?
length int?
value string

Returns

string

ConvertBinary(MappingSchema, BinaryExpression)

Searches for registered BinaryExpression mapping and returns LambdaExpression which has to replace this expression.

public static LambdaExpression? ConvertBinary(MappingSchema mappingSchema, BinaryExpression binaryExpression)

Parameters

mappingSchema MappingSchema

Current mapping schema.

binaryExpression BinaryExpression

Expression which has to be replaced.

Returns

LambdaExpression

Returns registered LambdaExpression or null.

ConvertMember(MappingSchema, Type?, MemberInfo) 

public static LambdaExpression? ConvertMember(MappingSchema mappingSchema, Type? objectType, MemberInfo mi)

Parameters

mappingSchema MappingSchema
objectType Type
mi MemberInfo

Returns

LambdaExpression

ConvertToCaseCompareTo(string?, string?) 

[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static int? ConvertToCaseCompareTo(string? str, string? value)

Parameters

str string
value string

Returns

int?

DateAdd(DateParts, int?, int?) 

[Sql.Extension("DateAdd", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.DateAddBuilder))]
public static DateTime? DateAdd(Sql.DateParts part, int? number, int? days)

Parameters

part Sql.DateParts
number int?
days int?

Returns

DateTime?

DecimalPI() 

[Sql.Function("PI", ServerSideOnly = true, CanBeNull = false)]
public static decimal DecimalPI()

Returns

decimal

DoublePI() 

[Sql.Function("PI", ServerSideOnly = true, CanBeNull = false)]
public static double DoublePI()

Returns

double

Hex(Guid?) 

[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static string? Hex(Guid? guid)

Parameters

guid Guid?

Returns

string

L<TR>(Expression<Func<TR>>) 

public static LambdaExpression L<TR>(Expression<Func<TR>> func)

Parameters

func Expression<Func<TR>>

Returns

LambdaExpression

Type Parameters

TR

L<T1, TR>(Expression<Func<T1, TR>>) 

public static LambdaExpression L<T1, TR>(Expression<Func<T1, TR>> func)

Parameters

func Expression<Func<T1, TR>>

Returns

LambdaExpression

Type Parameters

T1
TR

L<T1, T2, TR>(Expression<Func<T1, T2, TR>>) 

public static LambdaExpression L<T1, T2, TR>(Expression<Func<T1, T2, TR>> func)

Parameters

func Expression<Func<T1, T2, TR>>

Returns

LambdaExpression

Type Parameters

T1
T2
TR

L<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>>) 

public static LambdaExpression L<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> func)

Parameters

func Expression<Func<T1, T2, T3, TR>>

Returns

LambdaExpression

Type Parameters

T1
T2
T3
TR

L<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>>) 

public static LambdaExpression L<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> func)

Parameters

func Expression<Func<T1, T2, T3, T4, TR>>

Returns

LambdaExpression

Type Parameters

T1
T2
T3
T4
TR

L<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>>) 

public static LambdaExpression L<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> func)

Parameters

func Expression<Func<T1, T2, T3, T4, T5, TR>>

Returns

LambdaExpression

Type Parameters

T1
T2
T3
T4
T5
TR

L<T1, T2, T3, T4, T5, T6, TR>(Expression<Func<T1, T2, T3, T4, T5, T6, TR>>) 

public static LambdaExpression L<T1, T2, T3, T4, T5, T6, TR>(Expression<Func<T1, T2, T3, T4, T5, T6, TR>> func)

Parameters

func Expression<Func<T1, T2, T3, T4, T5, T6, TR>>

Returns

LambdaExpression

Type Parameters

T1
T2
T3
T4
T5
T6
TR

M<T>(Expression<Func<T, object?>>) 

public static MemberHelper.MemberInfoWithType M<T>(Expression<Func<T, object?>> func)

Parameters

func Expression<Func<T, object>>

Returns

MemberHelper.MemberInfoWithType

Type Parameters

T

M<T>(Expression<Func<T>>) 

public static MemberHelper.MemberInfoWithType M<T>(Expression<Func<T>> func)

Parameters

func Expression<Func<T>>

Returns

MemberHelper.MemberInfoWithType

Type Parameters

T

MakeDateTime2(int?, int?, int?) 

[Sql.Function("Access", "DateSerial", IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static DateTime? MakeDateTime2(int? year, int? month, int? day)

Parameters

year int?
month int?
day int?

Returns

DateTime?

MapBinary(ExpressionType, Type, Type, LambdaExpression)

Maps specific BinaryExpression to another LambdaExpression during SQL generation.

public static void MapBinary(ExpressionType nodeType, Type leftType, Type rightType, LambdaExpression expression)

Parameters

nodeType ExpressionType

NodeType of BinaryExpression ExpressionType which needs mapping.

leftType Type

Exact type of Left member.

rightType Type

Exact type of Right member.

expression LambdaExpression

Lambda expression which has to replace BinaryExpression.

Remarks

Note that method is not thread safe and has to be used only in Application's initialization section.

MapBinary(string, ExpressionType, Type, Type, LambdaExpression)

Maps specific BinaryExpression to another Lambda expression during SQL generation.

public static void MapBinary(string providerName, ExpressionType nodeType, Type leftType, Type rightType, LambdaExpression expression)

Parameters

providerName string

Name of database provider to use with this connection. ProviderName class for list of providers.

nodeType ExpressionType

NodeType of BinaryExpression ExpressionType which needs mapping.

leftType Type

Exact type of Left member.

rightType Type

Exact type of Right member.

expression LambdaExpression

Lambda expression which has to replace BinaryExpression

Remarks

Note that method is not thread safe and has to be used only in Application's initialization section.

MapBinary<TLeft, TRight, TR>(Expression<Func<TLeft, TRight, TR>>, Expression<Func<TLeft, TRight, TR>>)

Maps specific BinaryExpression to another LambdaExpression during SQL generation.

public static void MapBinary<TLeft, TRight, TR>(Expression<Func<TLeft, TRight, TR>> binaryExpression, Expression<Func<TLeft, TRight, TR>> expression)

Parameters

binaryExpression Expression<Func<TLeft, TRight, TR>>

Expression which has to be replaced.

expression Expression<Func<TLeft, TRight, TR>>

Lambda expression which has to replace binaryExpression.

Type Parameters

TLeft

Exact type of Left member.

TRight

Exact type of Right member.

TR

Result type of binaryExpression.

Remarks

Note that method is not thread safe and has to be used only in Application's initialization section.

MapBinary<TLeft, TRight, TR>(string, Expression<Func<TLeft, TRight, TR>>, Expression<Func<TLeft, TRight, TR>>)

Maps specific BinaryExpression to another LambdaExpression during SQL generation.

public static void MapBinary<TLeft, TRight, TR>(string providerName, Expression<Func<TLeft, TRight, TR>> binaryExpression, Expression<Func<TLeft, TRight, TR>> expression)

Parameters

providerName string

Name of database provider to use with this connection. ProviderName class for list of providers.

binaryExpression Expression<Func<TLeft, TRight, TR>>

Expression which has to be replaced.

expression Expression<Func<TLeft, TRight, TR>>

Lambda expression which has to replace binaryExpression.

Type Parameters

TLeft

Exact type of Left member.

TRight

Exact type of Right member.

TR

Result type of binaryExpression.

Remarks

Note that method is not thread safe and has to be used only in Application's initialization section.

MapMember(Expression<Func<object>>, LambdaExpression) 

public static void MapMember(Expression<Func<object>> memberInfo, LambdaExpression expression)

Parameters

memberInfo Expression<Func<object>>
expression LambdaExpression

MapMember(MemberInfo, IExpressionInfo) 

public static void MapMember(MemberInfo memberInfo, IExpressionInfo expressionInfo)

Parameters

memberInfo MemberInfo
expressionInfo IExpressionInfo

MapMember(MemberInfo, LambdaExpression) 

public static void MapMember(MemberInfo memberInfo, LambdaExpression expression)

Parameters

memberInfo MemberInfo
expression LambdaExpression

MapMember(string, MemberInfoWithType, LambdaExpression) 

public static void MapMember(string providerName, MemberHelper.MemberInfoWithType memberInfoWithType, LambdaExpression expression)

Parameters

providerName string
memberInfoWithType MemberHelper.MemberInfoWithType
expression LambdaExpression

MapMember(string, Expression<Func<object>>, LambdaExpression) 

public static void MapMember(string providerName, Expression<Func<object>> memberInfo, LambdaExpression expression)

Parameters

providerName string
memberInfo Expression<Func<object>>
expression LambdaExpression

MapMember(string, MemberInfo, IExpressionInfo) 

public static void MapMember(string providerName, MemberInfo memberInfo, IExpressionInfo expressionInfo)

Parameters

providerName string
memberInfo MemberInfo
expressionInfo IExpressionInfo

MapMember(string, MemberInfo, LambdaExpression) 

public static void MapMember(string providerName, MemberInfo memberInfo, LambdaExpression expression)

Parameters

providerName string
memberInfo MemberInfo
expression LambdaExpression

MapMember(string, Type, MemberInfo, IExpressionInfo) 

public static void MapMember(string providerName, Type objectType, MemberInfo memberInfo, IExpressionInfo expressionInfo)

Parameters

providerName string
objectType Type
memberInfo MemberInfo
expressionInfo IExpressionInfo

MapMember(string, Type, MemberInfo, LambdaExpression) 

public static void MapMember(string providerName, Type objectType, MemberInfo memberInfo, LambdaExpression expression)

Parameters

providerName string
objectType Type
memberInfo MemberInfo
expression LambdaExpression

MapMember(Type, MemberInfo, LambdaExpression) 

public static void MapMember(Type objectType, MemberInfo memberInfo, LambdaExpression expression)

Parameters

objectType Type
memberInfo MemberInfo
expression LambdaExpression

MapMember<T>(Expression<Func<T, object?>>, LambdaExpression) 

public static void MapMember<T>(Expression<Func<T, object?>> memberInfo, LambdaExpression expression)

Parameters

memberInfo Expression<Func<T, object>>
expression LambdaExpression

Type Parameters

T

MapMember<TR>(Expression<Func<TR>>, Expression<Func<TR>>) 

public static void MapMember<TR>(Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)

Parameters

memberInfo Expression<Func<TR>>
expression Expression<Func<TR>>

Type Parameters

TR

MapMember<T>(string, Expression<Func<T, object?>>, LambdaExpression) 

public static void MapMember<T>(string providerName, Expression<Func<T, object?>> memberInfo, LambdaExpression expression)

Parameters

providerName string
memberInfo Expression<Func<T, object>>
expression LambdaExpression

Type Parameters

T

MapMember<TR>(string, Expression<Func<TR>>, Expression<Func<TR>>) 

public static void MapMember<TR>(string providerName, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<TR>>
expression Expression<Func<TR>>

Type Parameters

TR

MapMember<TR>(string, Type, Expression<Func<TR>>, Expression<Func<TR>>) 

public static void MapMember<TR>(string providerName, Type objectType, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<TR>>
expression Expression<Func<TR>>

Type Parameters

TR

MapMember<TR>(Type, Expression<Func<TR>>, Expression<Func<TR>>) 

public static void MapMember<TR>(Type objectType, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<TR>>
expression Expression<Func<TR>>

Type Parameters

TR

MapMember<T1, TR>(Expression<Func<T1, TR>>, Expression<Func<T1, TR>>) 

public static void MapMember<T1, TR>(Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)

Parameters

memberInfo Expression<Func<T1, TR>>
expression Expression<Func<T1, TR>>

Type Parameters

T1
TR

MapMember<T1, TR>(string, Expression<Func<T1, TR>>, Expression<Func<T1, TR>>) 

public static void MapMember<T1, TR>(string providerName, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<T1, TR>>
expression Expression<Func<T1, TR>>

Type Parameters

T1
TR

MapMember<T1, TR>(string, Type, Expression<Func<T1, TR>>, Expression<Func<T1, TR>>) 

public static void MapMember<T1, TR>(string providerName, Type objectType, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<T1, TR>>
expression Expression<Func<T1, TR>>

Type Parameters

T1
TR

MapMember<T1, TR>(Type, Expression<Func<T1, TR>>, Expression<Func<T1, TR>>) 

public static void MapMember<T1, TR>(Type objectType, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<T1, TR>>
expression Expression<Func<T1, TR>>

Type Parameters

T1
TR

MapMember<T1, T2, TR>(Expression<Func<T1, T2, TR>>, Expression<Func<T1, T2, TR>>) 

public static void MapMember<T1, T2, TR>(Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)

Parameters

memberInfo Expression<Func<T1, T2, TR>>
expression Expression<Func<T1, T2, TR>>

Type Parameters

T1
T2
TR

MapMember<T1, T2, TR>(string, Expression<Func<T1, T2, TR>>, Expression<Func<T1, T2, TR>>) 

public static void MapMember<T1, T2, TR>(string providerName, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<T1, T2, TR>>
expression Expression<Func<T1, T2, TR>>

Type Parameters

T1
T2
TR

MapMember<T1, T2, TR>(string, Type, Expression<Func<T1, T2, TR>>, Expression<Func<T1, T2, TR>>) 

public static void MapMember<T1, T2, TR>(string providerName, Type objectType, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<T1, T2, TR>>
expression Expression<Func<T1, T2, TR>>

Type Parameters

T1
T2
TR

MapMember<T1, T2, TR>(Type, Expression<Func<T1, T2, TR>>, Expression<Func<T1, T2, TR>>) 

public static void MapMember<T1, T2, TR>(Type objectType, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<T1, T2, TR>>
expression Expression<Func<T1, T2, TR>>

Type Parameters

T1
T2
TR

MapMember<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>>, Expression<Func<T1, T2, T3, TR>>) 

public static void MapMember<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)

Parameters

memberInfo Expression<Func<T1, T2, T3, TR>>
expression Expression<Func<T1, T2, T3, TR>>

Type Parameters

T1
T2
T3
TR

MapMember<T1, T2, T3, TR>(string, Expression<Func<T1, T2, T3, TR>>, Expression<Func<T1, T2, T3, TR>>) 

public static void MapMember<T1, T2, T3, TR>(string providerName, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<T1, T2, T3, TR>>
expression Expression<Func<T1, T2, T3, TR>>

Type Parameters

T1
T2
T3
TR

MapMember<T1, T2, T3, TR>(string, Type, Expression<Func<T1, T2, T3, TR>>, Expression<Func<T1, T2, T3, TR>>) 

public static void MapMember<T1, T2, T3, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<T1, T2, T3, TR>>
expression Expression<Func<T1, T2, T3, TR>>

Type Parameters

T1
T2
T3
TR

MapMember<T1, T2, T3, TR>(Type, Expression<Func<T1, T2, T3, TR>>, Expression<Func<T1, T2, T3, TR>>) 

public static void MapMember<T1, T2, T3, TR>(Type objectType, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<T1, T2, T3, TR>>
expression Expression<Func<T1, T2, T3, TR>>

Type Parameters

T1
T2
T3
TR

MapMember<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>>, Expression<Func<T1, T2, T3, T4, TR>>) 

public static void MapMember<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)

Parameters

memberInfo Expression<Func<T1, T2, T3, T4, TR>>
expression Expression<Func<T1, T2, T3, T4, TR>>

Type Parameters

T1
T2
T3
T4
TR

MapMember<T1, T2, T3, T4, TR>(string, Expression<Func<T1, T2, T3, T4, TR>>, Expression<Func<T1, T2, T3, T4, TR>>) 

public static void MapMember<T1, T2, T3, T4, TR>(string providerName, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<T1, T2, T3, T4, TR>>
expression Expression<Func<T1, T2, T3, T4, TR>>

Type Parameters

T1
T2
T3
T4
TR

MapMember<T1, T2, T3, T4, TR>(string, Type, Expression<Func<T1, T2, T3, T4, TR>>, Expression<Func<T1, T2, T3, T4, TR>>) 

public static void MapMember<T1, T2, T3, T4, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<T1, T2, T3, T4, TR>>
expression Expression<Func<T1, T2, T3, T4, TR>>

Type Parameters

T1
T2
T3
T4
TR

MapMember<T1, T2, T3, T4, TR>(Type, Expression<Func<T1, T2, T3, T4, TR>>, Expression<Func<T1, T2, T3, T4, TR>>) 

public static void MapMember<T1, T2, T3, T4, TR>(Type objectType, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<T1, T2, T3, T4, TR>>
expression Expression<Func<T1, T2, T3, T4, TR>>

Type Parameters

T1
T2
T3
T4
TR

MapMember<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>>, Expression<Func<T1, T2, T3, T4, T5, TR>>) 

public static void MapMember<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)

Parameters

memberInfo Expression<Func<T1, T2, T3, T4, T5, TR>>
expression Expression<Func<T1, T2, T3, T4, T5, TR>>

Type Parameters

T1
T2
T3
T4
T5
TR

MapMember<T1, T2, T3, T4, T5, TR>(string, Expression<Func<T1, T2, T3, T4, T5, TR>>, Expression<Func<T1, T2, T3, T4, T5, TR>>) 

public static void MapMember<T1, T2, T3, T4, T5, TR>(string providerName, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)

Parameters

providerName string
memberInfo Expression<Func<T1, T2, T3, T4, T5, TR>>
expression Expression<Func<T1, T2, T3, T4, T5, TR>>

Type Parameters

T1
T2
T3
T4
T5
TR

MapMember<T1, T2, T3, T4, T5, TR>(string, Type, Expression<Func<T1, T2, T3, T4, T5, TR>>, Expression<Func<T1, T2, T3, T4, T5, TR>>) 

public static void MapMember<T1, T2, T3, T4, T5, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)

Parameters

providerName string
objectType Type
memberInfo Expression<Func<T1, T2, T3, T4, T5, TR>>
expression Expression<Func<T1, T2, T3, T4, T5, TR>>

Type Parameters

T1
T2
T3
T4
T5
TR

MapMember<T1, T2, T3, T4, T5, TR>(Type, Expression<Func<T1, T2, T3, T4, T5, TR>>, Expression<Func<T1, T2, T3, T4, T5, TR>>) 

public static void MapMember<T1, T2, T3, T4, T5, TR>(Type objectType, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)

Parameters

objectType Type
memberInfo Expression<Func<T1, T2, T3, T4, T5, TR>>
expression Expression<Func<T1, T2, T3, T4, T5, TR>>

Type Parameters

T1
T2
T3
T4
T5
TR

Mdy(int?, int?, int?) 

[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static DateTime? Mdy(int? month, int? day, int? year)

Parameters

month int?
day int?
year int?

Returns

DateTime?

N(Func<LambdaExpression>) 

public static Expressions.LazyExpressionInfo N(Func<LambdaExpression> func)

Parameters

func Func<LambdaExpression>

Returns

Expressions.LazyExpressionInfo

Replicate(char?, int?) 

[CLSCompliant(false)]
[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("DB2", "Repeat", IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("PostgreSQL", "Repeat", IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("Access", "string", new int[] { 1, 0 }, IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static string? Replicate(char? ch, int? count)

Parameters

ch char?
count int?

Returns

string

Replicate(string?, int?) 

[CLSCompliant(false)]
[Sql.Function(IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("DB2", "Repeat", IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("PostgreSQL", "Repeat", IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
[Sql.Function("Access", "string", new int[] { 1, 0 }, IsNullable = Sql.IsNullableType.IfAnyParameterNullable)]
public static string? Replicate(string? str, int? count)

Parameters

str string
count int?

Returns

string

Round(decimal?, int, int) 

[Sql.Function(IsNullable = Sql.IsNullableType.SameAsFirstParameter)]
public static decimal? Round(decimal? value, int precision, int mode)

Parameters

value decimal?
precision int
mode int

Returns

decimal?

Round(double?, int, int) 

[Sql.Function(IsNullable = Sql.IsNullableType.SameAsFirstParameter)]
public static double? Round(double? value, int precision, int mode)

Parameters

value double?
precision int
mode int

Returns

double?

SetGenericInfoProvider(Type) 

public static void SetGenericInfoProvider(Type type)

Parameters

type Type

TrimLeft(string?, params char[]) 

[CLSCompliant(false)]
[Sql.Expression("Firebird", "TRIM(LEADING FROM {0})", ServerSideOnly = false, PreferServerSide = false)]
[Sql.Extension("ClickHouse", "trim(LEADING {1} FROM {0})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("SqlServer.2022", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("DB2", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("Informix", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("Oracle", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("PostgreSQL", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("SapHana", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Extension("SQLite", "LTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.LTrimCharactersBuilder))]
[Sql.Function("LTrim", new int[] { 0 }, IsNullable = Sql.IsNullableType.SameAsFirstParameter)]
public static string? TrimLeft(string? str, params char[] trimChars)

Parameters

str string
trimChars char[]

Returns

string

TrimRight(string?, params char[]) 

[CLSCompliant(false)]
[Sql.Expression("Firebird", "TRIM(TRAILING FROM {0})", ServerSideOnly = false, PreferServerSide = false)]
[Sql.Extension("ClickHouse", "trim(TRAILING {1} FROM {0})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("SqlServer.2022", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("DB2", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("Informix", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("Oracle", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("PostgreSQL", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("SapHana", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Extension("SQLite", "RTRIM({0}, {1})", ServerSideOnly = false, PreferServerSide = false, BuilderType = typeof(Expressions.RTrimCharactersBuilder))]
[Sql.Function("RTrim", new int[] { 0 }, IsNullable = Sql.IsNullableType.SameAsFirstParameter)]
public static string? TrimRight(string? str, params char[] trimChars)

Parameters

str string
trimChars char[]

Returns

string

VarChar(object?, int?) 

[Sql.Function(IsNullable = Sql.IsNullableType.SameAsFirstParameter)]
public static string? VarChar(object? obj, int? size)

Parameters

obj object
size int?

Returns

string