Beyond Relational with Entity Framework
summary
Shows concrete recipes: EF Core 7 JSON mapping that stores and queries JSON on SQL Server (with fallback to FromSql), computed columns and indexes for JSON paths, and value-converter fallback for other RDBMS; explains temporal tables in SQL Server for automatic history with period columns and Entity Framework temporal querying; demonstrates querying hierarchical data using hierarchyid and notes EF8 preview adds primitive collection and hierarchyid support; examples translate to SQL, change tracking and indexing actually work, temporal is SQL Server only.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 1:07Storing JSON with EF
- 7:15Why use JSON in SQL
- 11:33JSON in EF Core
- 19:25JSON in PostgreSQL
- 21:38Temporal tables
- 29:37Hierarchical data with hierarchyid
- 34:32EF8 new features
- 35:14Q&A
related talks
59mBeyond Relational With Entity Framework
44m10 things you didn't know EF Core can do
43mEF Core 8 overview and demo
59m10 things you didn't know EF Core can do
50mEntity Framework Core 2.2 and beyond: what's cooking?
56mExciting new features in SQL Server for developers
01h 00mGetting the best out of Entity Framework Core
01h 01m10 things you didn't know EF Core can do