EntityFrameworkCore.TemporalTables
EntityFrameworkCore.TemporalTables copied to clipboard
findulov
Extension library which allows developers to easily use temporal tables in SQL Server using Entity Framework Core.
I upgraded my project to EF6 and this library no longer works, so I enabled temporal tables for my entities using EF6 integrated system. However when I create a new...
Our project was working with all new tables created Temporal. We have modelBuilder.UseTemporalTables(); in our OnModelCreating. But now for some reason tables created with migrationBuilder.CreateTable() are no longer created as...
I couldn't find any docs on how to fire some temportal queries using linq are there any samples or is this not supported?
I am looking for an example or help on using views along side temporal tables. My current implementation results in an exception when updating the database. I have used PreventTemporalTables...
Hi@findulov, I found an issue in the EntityFrameworkCore.TemporalTables.Tests.csproj: Packages Microsoft.EntityFrameworkCore v5.0.0, Microsoft.EntityFrameworkCore.Design v5.0.0, Microsoft.EntityFrameworkCore.InMemory v5.0.0, Microsoft.EntityFrameworkCore.Relational v5.0.0, Microsoft.NET.Test.Sdk v16.5.0 and MSTest.TestAdapter v2.1.0 transitively introduce 93 dependencies into EntityFrameworkCore.TemporalTables’s dependency graph...
It coulld be nice to add the possibility to add retention policy for all/specific historical tables. [https://docs.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver15#using-temporal-history-retention-policy-approach](https://docs.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver15#using-temporal-history-retention-policy-approach)
Hi, Is the dependency on .net standard 2.1 and _not_ 2.0 mandatory? My client project (Blazor) has a strong dependency on .net standard 2.0 and therefore cannot reference the DAL...
This PR may be a little premature. I have a need to be able to see the period columns when querying the complete history of an entity. Since the period...
Hello, Is it possible to .Include model with AS OF that is related to the main model? something like this? `return DbSet.AsTemporalAsOf(datetime) .IncludeTemporal(x => x.TemporalData).ToList()`
