Class TemporalClause

Namespace

NextORM.Core

Assembly

nextorm.core.dll

The FOR SYSTEM_TIME temporal-table clause attached to a query through EntityBuilder.ForSystemTime. Create it with one of the static factory methods; the native syntax is rendered by the provider dialect.

public sealed record TemporalClause : IEquatable<TemporalClause>

Inheritance

object

TemporalClause

Implements

IEquatable<TemporalClause>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Properties

From

The AS OF point, or the start of the range.

public DateTime From { get; }

Property Value

DateTime

Kind

Which temporal clause is applied.

public TemporalKind Kind { get; }

Property Value

TemporalKind

To

The end of the range; unused by AsOf and All.

public DateTime To { get; }

Property Value

DateTime

Methods

All()

Every row version (ALL).

public static TemporalClause All()

Returns

TemporalClause

AsOf(DateTime)

Rows that were valid at point in time (AS OF).

public static TemporalClause AsOf(DateTime point)

Parameters

point DateTime

The point in time to query.

Returns

TemporalClause

Between(DateTime, DateTime)

Rows valid at some point in the closed-open range (BETWEEN ... AND ...).

public static TemporalClause Between(DateTime from, DateTime to)

Parameters

from DateTime

The inclusive range start.

to DateTime

The range end; must be after from.

Returns

TemporalClause

ContainedIn(DateTime, DateTime)

Rows whose validity period lies entirely within the range (CONTAINED IN).

public static TemporalClause ContainedIn(DateTime from, DateTime to)

Parameters

from DateTime

The inclusive range start.

to DateTime

The inclusive range end; must be after from.

Returns

TemporalClause

FromTo(DateTime, DateTime)

Rows valid in the closed-open range (FROM ... TO ...).

public static TemporalClause FromTo(DateTime from, DateTime to)

Parameters

from DateTime

The inclusive range start.

to DateTime

The exclusive range end; must be after from.

Returns

TemporalClause