SqlServerDbSetExtensions Class

Definition

Namespace:

Microsoft.EntityFrameworkCore

Assembly:

Microsoft.EntityFrameworkCore.SqlServer.dll

Package:

Microsoft.EntityFrameworkCore.SqlServer v6.0.0

Sql Server database specific extension methods for LINQ queries rooted in DbSet.

public static class SqlServerDbSetExtensions

type SqlServerDbSetExtensions = class

Public Module SqlServerDbSetExtensions

Inheritance

Object

SqlServerDbSetExtensions

Methods

TemporalAll<TEntity>(DbSet<TEntity>)	Applies temporal 'All' operation on the given DbSet, which returns all historical versions of the entities as well as their current state. Temporal queries are always set as 'NoTracking'.
TemporalAsOf<TEntity>(DbSet<TEntity>, DateTime)	Applies temporal 'AsOf' operation on the given DbSet, which only returns elements that were present in the database at a given point in time. Temporal information is stored in UTC format on the database, so any DateTime arguments in local time may lead to unexpected results. Temporal queries are always set as 'NoTracking'.
TemporalBetween<TEntity>(DbSet<TEntity>, DateTime, DateTime)	Applies temporal 'Between' operation on the given DbSet, which only returns elements that were present in the database between two points in time. Elements that were created at the starting point are not included in the results, however elements that were removed at the end point are included in the results. All versions of entities in that were present within the time range are returned, so it is possible to return multiple entities with the same key. Temporal information is stored in UTC format on the database, so any DateTime arguments in local time may lead to unexpected results. Temporal queries are always set as 'NoTracking'.
TemporalContainedIn<TEntity>(DbSet<TEntity>, DateTime, DateTime)	Applies temporal 'ContainedIn' operation on the given DbSet, which only returns elements that were present in the database between two points in time. Elements that were created at the starting point as well as elements that were removed at the end point are included in the results. All versions of entities in that were present within the time range are returned, so it is possible to return multiple entities with the same key. Temporal information is stored in UTC format on the database, so any DateTime arguments in local time may lead to unexpected results. Temporal queries are always set as 'NoTracking'.
TemporalFromTo<TEntity>(DbSet<TEntity>, DateTime, DateTime)	Applies temporal 'FromTo' operation on the given DbSet, which only returns elements that were present in the database between two points in time. Elements that were created at the starting point as well as elements that were removed at the end point are not included in the results. All versions of entities in that were present within the time range are returned, so it is possible to return multiple entities with the same key. Temporal information is stored in UTC format on the database, so any DateTime arguments in local time may lead to unexpected results. Temporal queries are always set as 'NoTracking'.