SQL Server Temporal Tables in EF Core 6.0

SQL Server temporal tables automatically keep track of all data ever stored in a table, even after that data has been updated or deleted using a parallel history table. Using history table, we can query the historical data, or even we can restore them.

In .NET Conf 2021-Pakistan I have talked about using SQL Server Temporal Tables in EF Core 6.0. During this session I have talked about:

  • What is SQL Server Temporal Table?
  • Configuring a temporal table
  • Using temporal tables
  • Querying historical data
  • Restoring historical data

You can watch this talk in .NET Conf 2021-Pakistan via YouTube.

You can also get access to this session’s source code via GitHub at: https://github.com/VahidFarahmandian/efcore6-sql-temporal-tables

--

--

Vahid Farahmandian

Mainly a .Net #developer, sometimes #SQLServer admin, not yet a husband and specifically not a father. My LinkedIn: https://www.linkedin.com/in/vfarahmandian/