Beyond Relational With Entity Framework
summary
Shows EF Core using SQL Server JSON functions like JSON_MODIFY and OPENJSON to query and partially update JSON columns, notes EF Core 7 support and EF Core 8 adding primitive collections and SQLite support, demonstrates computed-column indexes for fast JSON queries, uses temporal tables with system_versioning (period start/end, history table) and EF Core temporal query operators (AsOf, Between, All) but no automatic restore, and enables SQL Server hierarchyid via a NuGet provider with IsDescendantOf/GetLevel/GetAncestor and GetDescendant to insert between nodes.
AI-written summary · about
chapters (9)
- 0:00Non-relational EF features
- 1:25JSON in SQL Server
- 8:39Demo: JSON with EF
- 22:16Temporal tables overview
- 31:03Demo: Temporal tables with EF
- 38:42Temporal tables limits
- 39:45Hierarchical data in DBs
- 44:29Demo: Hierarchy ID with EF
- 53:12Summary
related talks
37mBeyond Relational with Entity Framework
43mEF Core 8 overview and demo
01h 01m10 things you didn't know EF Core can do
43mEF Core 9: Evolving Data Access in .NET
59m10 things you didn't know EF Core can do
44m10 things you didn't know EF Core can do
50mEntity Framework Core 2.2 and beyond: what's cooking?
01h 00mGetting the best out of Entity Framework Core