Enum SqlIntervalPartKind

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

Which of the two different readings of an interval component is requested.

public enum SqlIntervalPartKind

Extension Methods

Sql.Between<T>(T, T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T?)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T?)

Sql.NotBetween<T>(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>)

Fields

Component = 0

The component within the next coarser unit, truncated toward zero, as TimeSpan.Minutes does.

Total = 1

The whole interval expressed in the requested unit, keeping the fractional part, as TimeSpan.TotalMinutes does.

Remarks

The distinction is not cosmetic: for an interval of 90 minutes, Component of Minute is 30, while Total is 90. Collapsing them is the bug behind translating TimeSpan.TotalHours into a date-part boundary count.