Class SqlIntervalPartExpression

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

A component or a total of an interval, expressed in a requested unit.

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

Inheritance

object

QueryElement

SqlExpressionBase

SqlIntervalPartExpression

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

Component reproduces TimeSpan.Hours, truncating toward zero as CLR integer division does; Total reproduces TimeSpan.TotalHours and keeps the fraction. Provider division and modulo do not agree on negative values, so lowering must express the truncation explicitly rather than lean on the database's own rules.

Constructors

SqlIntervalPartExpression(ISqlExpression, SqlIntervalUnit, SqlIntervalPartKind, DbDataType, SqlIntervalUnit?)

public SqlIntervalPartExpression(ISqlExpression interval, SqlIntervalUnit unit, SqlIntervalPartKind kind, DbDataType type, SqlIntervalUnit? within = null)

Parameters

interval ISqlExpression

unit SqlIntervalUnit

kind SqlIntervalPartKind

type DbDataType

within SqlIntervalUnit?

Properties

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

Interval

Interval the part is taken from.

public ISqlExpression Interval { get; }

Property Value

ISqlExpression

Kind

Whether a component within an enclosing unit or the whole interval is requested.

public SqlIntervalPartKind Kind { get; }

Property Value

SqlIntervalPartKind

Precedence

public override int Precedence { get; }

Property Value

int

SystemType

public override Type? SystemType { get; }

Property Value

Type

Type

Result type - integral for Component, floating point for Total.

public DbDataType Type { get; }

Property Value

DbDataType

Unit

Unit the result is expressed in.

public SqlIntervalUnit Unit { get; }

Property Value

SqlIntervalUnit

Within

The unit a Component is counted within, or null when it is not counted within anything - TimeSpan.Days is the whole day count and does not wrap. Meaningless for Total.

public SqlIntervalUnit? Within { get; }

Property Value

SqlIntervalUnit?

Remarks

Stated rather than implied. "The next coarser unit" cannot express the two readings the same unit has - TimeSpan.Microseconds counts within the millisecond while DATEPART(microsecond, ...) counts within the second - and it is the enclosing unit, not this one, that decides whether a component survives a coarse measurement: nanoseconds within a microsecond stay meaningful at tick resolution, because a tick is a hundred of them.

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, SqlIntervalUnit, SqlIntervalPartKind, DbDataType, SqlIntervalUnit?)

public void Modify(ISqlExpression interval, SqlIntervalUnit unit, SqlIntervalPartKind kind, DbDataType type, SqlIntervalUnit? within)

Parameters

interval ISqlExpression

unit SqlIntervalUnit

kind SqlIntervalPartKind

type DbDataType

within SqlIntervalUnit?

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter