Entity Framework Community Standup - SQL Server Temporal Tables and EF Core 6

preview_player
Показать описание
Learn about the new support in EF Core 6 for temporal tables, including creating them from migrations, transforming existing tables into temporal tables, querying historical data and point-in-time restore.

​

#efcore #sqlserver #temporaltables
  1. dotnet
Рекомендации по теме
Entity Framework Community 0:49:38

Entity Framework Community Standup - Introducing EF Core Compiled Models

Entity Framework Community 1:07:23

Entity Framework Community Standup - EF Core with ASP.NET Core

.NET Data Community 1:33:10

.NET Data Community Standup - Entity Framework Core FAQs

Entity Framework Community 0:57:36

Entity Framework Community Standup - Visualizing database query plans

Entity Framework Community 1:03:01

Entity Framework Community Standup - Typed Exceptions for Entity Framework Core

Entity Framework Community 1:11:41

Entity Framework Community Standup - EF Core 6.0 Survey Results

Entity Framework Community 1:28:04

Entity Framework Community Standup - Make History and Explore the Cosmos, an EF Core 6 Retrospective

Entity Framework Community 0:59:41

Entity Framework Community Standup - Open Source Software (OSS) Projects for EF Core

Entity Framework Community 1:23:40

Entity Framework Community Standup - Noda Time

Entity Framework Community 1:15:21

Entity Framework Community Standup - The EF7 Plan

Entity Framework Community 1:03:33

Entity Framework Community Standup - Introducing MSBuild.Sdk.SqlProj

Entity Framework Community 1:19:21

Entity Framework Community Standup - Open Source Contributions: How to Add a Feature to EF Core

Entity Framework Community 1:05:45

Entity Framework Community Standup - Performance Tuning an EF Core App

Entity Framework: .NET 1:08:33

Entity Framework: .NET Community Standup - May 6th 2020 - Introducing the EF Core Community Standup

Entity Framework Community 1:16:44

Entity Framework Community Standup - Dapper

Entity Framework Community 0:59:06

Entity Framework Community Standup - Azure SQL for Cloud-Born Applications and Developers

Entity Framework Community 1:21:32

Entity Framework Community Standup - OData

Entity Framework Community 1:17:53

Entity Framework Community Standup - Hot Chocolate 12 and GraphQL 2021

Entity Framework Community 0:56:32

Entity Framework Community Standup - SQL Server Temporal Tables and EF Core 6

Entity Framework Community 1:06:46

Entity Framework Community Standup - EF Core's Global Query Filter

Entity Framework Community 1:10:43

Entity Framework Community Standup - Julie Lerman and EF Core Ask Me Anything (AMA)

Entity Framework Community 1:04:44

Entity Framework Community Standup - Sept 2nd 2020 - Sync your database with DotMim.Sync

Entity Framework Community 1:12:31

Entity Framework Community Standup - PostgreSQL and EF Core

Entity Framework Community 1:11:03

Entity Framework Community Standup - EF Core 5.0 Collations

Комментарии
Автор

What tool is he using to get to the Debug View @31:47? How to I access that window in Visual Studio?

jaredklements
Автор

(joined after intro and missed the fact that it queries the built-in! SQL-Svr feature, grrrr) Had recently discovered temporal tables in a feasibility analysis. This EF-features gives it a push forward to be applied 👍🏼

gregcyrus
Автор

@ajcvickers At 44:06 you say "When you use temporal tables SQL Server doesn't support CASCADE DELETE..". That is true in the lowest mssql version this feature supports (SQL 2016), but SQL 2019 does support it. I'd like to use temporal tables for "user, role, permission" tables with audit for "UserRole" mapping table, especially to track when roles are removed/added to a user. Currently using EFCore and SQL 2019. What's the best forum to clarify such support? GitHub issue?

ChrisTracy
Автор

The concept of temporal tables is great but the implementation sucks. The history table does not contain any indexes from the table it contains history for. So if I query history for a specific ID and the history table does not contain an index on that column is bad design.

UnknownMoses