Class SqlIntervalDifferenceExpression

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

The interval elapsed between two temporal values.

public sealed class SqlIntervalDifferenceExpression : SqlExpressionBase, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>

Inheritance

object

QueryElement

SqlExpressionBase

SqlIntervalDifferenceExpression

Implements

ISqlExpression

IQueryElement

IEquatable<ISqlExpression>

Inherited Members

SqlExpressionBase.Equals(ISqlExpression)

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

SqlExpressionBase.CanBeNullable(NullabilityContext)

SqlExpressionBase.Precedence

SqlExpressionBase.SystemType

QueryElement.ReferenceComparer

QueryElement.ElementType

QueryElement.ToString(QueryElementTextWriter)

QueryElement.GetElementHashCode()

QueryElement.Accept(QueryElementVisitor)

Extension Methods

QueryHelper.AnyElement(IQueryElement, Func<IQueryElement, bool>)

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.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.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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

Remarks

The contract is exactly End - Start: elapsed time, signed, exact within the resolution of IntervalType. It is deliberately not a boundary count - Sql.DateDiff counts how many unit boundaries were crossed, which for 10:59 to 11:01 gives one hour where the elapsed duration is two minutes. Keeping the two apart in the AST is what stops that confusion from being reintroduced downstream.

There is no unit on this node. It produces a whole interval, not "a number of hours" - a unit only becomes meaningful when a part or a total is requested, which is SqlIntervalPartExpression.

Constructors

SqlIntervalDifferenceExpression(ISqlExpression, ISqlExpression, DbDataType, SqlIntervalType)

public SqlIntervalDifferenceExpression(ISqlExpression start, ISqlExpression end, DbDataType type, SqlIntervalType intervalType)

Parameters

start ISqlExpression

end ISqlExpression

type DbDataType

intervalType SqlIntervalType

Properties

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

End

Minuend - the later value in a positive result.

public ISqlExpression End { get; }

Property Value

ISqlExpression

IntervalType

Logical type of the produced interval.

public SqlIntervalType IntervalType { get; }

Property Value

SqlIntervalType

Precedence

public override int Precedence { get; }

Property Value

int

Start

Subtrahend - the earlier value in a positive result.

public ISqlExpression Start { get; }

Property Value

ISqlExpression

SystemType

public override Type? SystemType { get; }

Property Value

Type

Type

public DbDataType Type { get; }

Property Value

DbDataType

Methods

Accept(QueryElementVisitor)

Visitor support.

public override IQueryElement Accept(QueryElementVisitor visitor)

Parameters

visitor QueryElementVisitor

Returns

IQueryElement

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(ISqlExpression, ISqlExpression, DbDataType, SqlIntervalType)

public void Modify(ISqlExpression start, ISqlExpression end, DbDataType type, SqlIntervalType intervalType)

Parameters

start ISqlExpression

end ISqlExpression

type DbDataType

intervalType SqlIntervalType

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter