Class SqlExtendedFunction

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

public class SqlExtendedFunction : SqlExpressionBase, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>

Inheritance

object

QueryElement

SqlExpressionBase

SqlExtendedFunction

Implements

ISqlExpression

IQueryElement

IEquatable<ISqlExpression>

Inherited Members

SqlExpressionBase.Equals(ISqlExpression)

QueryElement.ReferenceComparer

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

QueryHelper.CanBeEvaluated(IQueryElement, EvaluationContext)

QueryHelper.CanBeEvaluated(IQueryElement, bool)

QueryHelper.EvaluateBoolExpression(IQueryElement, EvaluationContext, bool?)

QueryHelper.EvaluateExpression(IQueryElement, EvaluationContext)

QueryHelper.HasElement(IQueryElement, IQueryElement)

QueryHelper.HasParameter(IQueryElement)

QueryHelper.HasQueryParameter(IQueryElement)

QueryHelper.IsMutable(IQueryElement)

QueryHelper.TryEvaluateExpression(IQueryElement, EvaluationContext, out object?)

QueryHelper.TryEvaluateExpressionForServer(IQueryElement, EvaluationContext, out object?)

QueryVisitorExtensions.Find(IQueryElement?, QueryElementType)

QueryVisitorExtensions.Find(IQueryElement?, Func<IQueryElement, bool>)

QueryVisitorExtensions.FindExcept<TContext>(IQueryElement?, TContext, IQueryElement, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Find<TContext>(IQueryElement?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

QueryVisitorExtensions.VisitParentFirst(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirst<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

QueryHelper.CanBeNullableOrUnknown(ISqlExpression, NullabilityContext, bool)

QueryHelper.IsNullValue(ISqlExpression)

QueryHelper.IsPredicate(ISqlExpression)

QueryHelper.ShouldCheckForNull(ISqlExpression, NullabilityContext)

ISqlExpressionExtensions.AreEqual(ISqlExpression?, ISqlExpression?, Func<ISqlExpression, ISqlExpression, bool>)

QueryVisitorExtensions.Clone<T>(T?)

QueryVisitorExtensions.Clone<T>(T?, Dictionary<IQueryElement, IQueryElement>)

QueryVisitorExtensions.Clone<T>(T?, Func<IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Dictionary<IQueryElement, IQueryElement>, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.ConvertAll<T>(T, bool, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<T>(T, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<T>(T, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Replace<T>(T, IDictionary<IQueryElement, IQueryElement>, params IQueryElement[])

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Constructors

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

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

Parameters

dbDataType DbDataType

functionName string

arguments IEnumerable<SqlFunctionArgument>

argumentsNullability bool[]

canBeNull bool?

withinGroup IEnumerable<SqlWindowOrderItem>

partitionBy IEnumerable<ISqlExpression>

orderBy IEnumerable<SqlWindowOrderItem>

filter SqlSearchCondition

frameClause SqlFrameClause

isAggregate bool

canBeAffectedByOrderBy bool

Properties

Arguments

public List<SqlFunctionArgument> Arguments { get; }

Property Value

List<SqlFunctionArgument>

ArgumentsNullability

public bool[] ArgumentsNullability { get; }

Property Value

bool[]

CanBeAffectedByOrderBy

public bool CanBeAffectedByOrderBy { get; }

Property Value

bool

CanBeNull

public bool? CanBeNull { get; }

Property Value

bool?

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

Filter

public SqlSearchCondition? Filter { get; }

Property Value

SqlSearchCondition

FrameClause

public SqlFrameClause? FrameClause { get; }

Property Value

SqlFrameClause

FunctionName

public string FunctionName { get; }

Property Value

string

IsAggregate

public bool IsAggregate { get; }

Property Value

bool

IsWindowFunction

public bool IsWindowFunction { get; }

Property Value

bool

OrderBy

public List<SqlWindowOrderItem>? OrderBy { get; }

Property Value

List<SqlWindowOrderItem>

PartitionBy

public List<ISqlExpression>? PartitionBy { get; }

Property Value

List<ISqlExpression>

Precedence

public override int Precedence { get; }

Property Value

int

SystemType

public override Type SystemType { get; }

Property Value

Type

Type

public DbDataType Type { get; }

Property Value

DbDataType

WithinGroup

public List<SqlWindowOrderItem>? WithinGroup { get; }

Property Value

List<SqlWindowOrderItem>

Methods

CanBeNullable(NullabilityContext)

public override bool CanBeNullable(NullabilityContext nullability)

Parameters

nullability NullabilityContext

Returns

bool

Equals(ISqlExpression, Func<ISqlExpression, ISqlExpression, bool>)

public override bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)

Parameters

other ISqlExpression

comparer Func<ISqlExpression, ISqlExpression, bool>

Returns

bool

GetElementHashCode()

public override int GetElementHashCode()

Returns

int

Modify(List<SqlFunctionArgument>, List<SqlWindowOrderItem>?, List<ISqlExpression>?, List<SqlWindowOrderItem>?, SqlSearchCondition?, SqlFrameClause?)

public void Modify(List<SqlFunctionArgument> arguments, List<SqlWindowOrderItem>? withinGroup, List<ISqlExpression>? partitionBy, List<SqlWindowOrderItem>? orderBy, SqlSearchCondition? filter, SqlFrameClause? frameClause)

Parameters

arguments List<SqlFunctionArgument>

withinGroup List<SqlWindowOrderItem>

partitionBy List<ISqlExpression>

orderBy List<SqlWindowOrderItem>

filter SqlSearchCondition

frameClause SqlFrameClause

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter

WithArguments(IEnumerable<SqlFunctionArgument>, bool[])

public SqlExtendedFunction WithArguments(IEnumerable<SqlFunctionArgument> arguments, bool[] argumentsNullability)

Parameters

arguments IEnumerable<SqlFunctionArgument>

argumentsNullability bool[]

Returns

SqlExtendedFunction

WithFilter(SqlSearchCondition?)

public SqlExtendedFunction WithFilter(SqlSearchCondition? filter)

Parameters

filter SqlSearchCondition

Returns

SqlExtendedFunction

WithFrameClause(SqlFrameClause?)

public SqlExtendedFunction WithFrameClause(SqlFrameClause? frameClause)

Parameters

frameClause SqlFrameClause

Returns

SqlExtendedFunction

WithFunctionName(string)

public SqlExtendedFunction WithFunctionName(string functionName)

Parameters

functionName string

Returns

SqlExtendedFunction

WithOrderBy(IEnumerable<SqlWindowOrderItem>?)

public SqlExtendedFunction WithOrderBy(IEnumerable<SqlWindowOrderItem>? orderBy)

Parameters

orderBy IEnumerable<SqlWindowOrderItem>

Returns

SqlExtendedFunction

WithPartitionBy(IEnumerable<ISqlExpression>?)

public SqlExtendedFunction WithPartitionBy(IEnumerable<ISqlExpression>? partitionBy)

Parameters

partitionBy IEnumerable<ISqlExpression>

Returns

SqlExtendedFunction

WithType(DbDataType)

public SqlExtendedFunction WithType(DbDataType dbDataType)

Parameters

dbDataType DbDataType

Returns

SqlExtendedFunction

WithWithinGroup(IEnumerable<SqlWindowOrderItem>?)

public SqlExtendedFunction WithWithinGroup(IEnumerable<SqlWindowOrderItem>? withinGroup)

Parameters

withinGroup IEnumerable<SqlWindowOrderItem>

Returns

SqlExtendedFunction