Class Sql.FunctionAttribute

Defines an SQL server-side Function with parameters passed in.

Inheritance

System.Object

MappingAttribute

Sql.ExpressionAttribute

Sql.FunctionAttribute

Inherited Members

Sql.ExpressionAttribute.Expression

Sql.ExpressionAttribute.ArgIndices

Sql.ExpressionAttribute.Precedence

Sql.ExpressionAttribute.Configuration

Sql.ExpressionAttribute.ServerSideOnly

Sql.ExpressionAttribute.PreferServerSide

Sql.ExpressionAttribute.InlineParameters

Sql.ExpressionAttribute.ExpectExpression

Sql.ExpressionAttribute.IsPredicate

Sql.ExpressionAttribute.IsAggregate

Sql.ExpressionAttribute.IsWindowFunction

Sql.ExpressionAttribute.IsPure

Sql.ExpressionAttribute.IsNullable

Sql.ExpressionAttribute.IgnoreGenericParameters

Sql.ExpressionAttribute.CanBeNull

Sql.ExpressionAttribute.GetCanBeNull(ISqlExpression[])

Sql.ExpressionAttribute.CalcCanBeNull(Sql.IsNullableType, IEnumerable<Boolean>)

Sql.ExpressionAttribute.ResolveExpressionValues<TContext>(TContext, String, Func<TContext, String, Nullable<String>, Nullable<String>>)

Sql.ExpressionAttribute.UnknownExpression

Sql.ExpressionAttribute.PrepareParameterValues<TContext>(TContext, MappingSchema, Expression, Nullable<String>, Boolean, List<Nullable<Expression>>, Boolean, Nullable<List<SqlDataType>>, Func<TContext, Expression, ColumnDescriptor, ISqlExpression>)

Sql.ExpressionAttribute.PrepareArguments<TContext>(TContext, String, Int32[], Boolean, List<Nullable<Expression>>, Nullable<List<SqlDataType>>, Func<TContext, Expression, ColumnDescriptor, ISqlExpression>)

Sql.ExpressionAttribute.GetIsPredicate(Expression)

Namespace: LinqToDB

Assembly: linq2db.dll

Syntax

public class FunctionAttribute : Sql.ExpressionAttribute

Constructors

FunctionAttribute()

Defines an SQL Function, which shall be the same as the name as the function called.

Declaration

public FunctionAttribute()

FunctionAttribute(String)

Defines an SQL function with the given name.

Declaration

public FunctionAttribute(string name)

Parameters

Type	Name	Description
System.String	name	The name of the function. no parenthesis () should be used.

FunctionAttribute(String, Int32[])

Defines an SQL function with the given name.

Declaration

public FunctionAttribute(string name, params int[] argIndices)

Parameters

Type	Name	Description
System.String	name	The name of the function. no parenthesis () should be used.
System.Int32[]	argIndices	Used for setting the order of the method arguments being passed into the function.

FunctionAttribute(String, String)

Defines an SQL function with the given name, for the ProviderName given.

Declaration

public FunctionAttribute(string configuration, string name)

Parameters

Type	Name	Description
System.String	configuration	The Database configuration for which this Expression will be used.
System.String	name	The name of the function. no parenthesis () should be used.

FunctionAttribute(String, String, Int32[])

Defines an SQL function with the given name, for the ProviderName given.

Declaration

public FunctionAttribute(string configuration, string name, params int[] argIndices)

Parameters

Type	Name	Description
System.String	configuration	The Database configuration for which this Expression will be used.
System.String	name	The name of the function. no parenthesis () should be used.
System.Int32[]	argIndices	Used for setting the order of the method arguments being passed into the function.

Properties

Name

The name of the Database Function

Declaration

public string? Name { get; set; }

Property Value

Type	Description
System.Nullable<System.String>

Methods

GetExpression<TContext>(TContext, IDataContext, SelectQuery, Expression, Func<TContext, Expression, ColumnDescriptor, ISqlExpression>)

Declaration

public override ISqlExpression GetExpression<TContext>(TContext context, IDataContext dataContext, SelectQuery query, Expression expression, Func<TContext, Expression, ColumnDescriptor, ISqlExpression> converter)

Parameters

Type	Name	Description
TContext	context
IDataContext	dataContext
SelectQuery	query
Expression	expression
Func<TContext, Expression, ColumnDescriptor, ISqlExpression>	converter

Returns

Type	Description
ISqlExpression

Type Parameters

Name	Description
TContext

Overrides

LinqToDB.Sql.ExpressionAttribute.GetExpression<TContext>(TContext, LinqToDB.IDataContext, LinqToDB.SqlQuery.SelectQuery, Expression, Func<TContext, Expression, LinqToDB.Mapping.ColumnDescriptor, LinqToDB.SqlQuery.ISqlExpression>)

GetObjectID()

Declaration

public override string GetObjectID()

Returns

Type	Description
System.String

Overrides

Sql.ExpressionAttribute.GetObjectID()

Extension Methods

Map.DeepCopy<T>(T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, T[])

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T[])

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)