10 things you didn't know EF Core can do
summary
Ten concrete EF Core capabilities appear with concrete limits and demos: value‑type properties replace complex types for faster in‑row mapping, implicit many‑to‑many avoids mapping join entities, and hierarchy ID (SQL Server) mapped via SqlServer.HierarchyId package enables single‑query descendant/level queries — demo shows initial config hiccups then working queries. Also: raw SQL materialized like Dapper, JSON columns for nested owned types written to one column, batching, inheritance strategies, logical deletes via shadow props+filters+SaveChanges interception, compiled queries, and the multi‑database DBContext item is revealed as fake.
AI-written summary · about
chapters (20)
- 0:00Introduction
- 2:38EF Core features overview
- 3:41Value type properties
- 4:23Many-to-many without tables
- 4:47Hierarchical IDs for trees
- 6:12Raw SQL queries
- 6:54JSON columns
- 7:58Batching SQL statements
- 9:00Single DbContext multi-DB
- 10:08Inheritance mapping strategies
- 12:56Logical deletes with shadow props
- 14:44Compiling queries
- 16:11DbContext without DbSets
- 18:14Fake feature demo vote
- 21:07Hierarchical IDs setup
- 28:18Hierarchical IDs demo
- 31:40Querying hierarchical data
- 34:56JSON columns demo
- 39:57JSON columns results
- 41:45Conclusion & Q&A
related talks
59m10 things you didn't know EF Core can do
01h 01m10 things you didn't know EF Core can do
43mEF Core 8 overview and demo
47mEF Core 6: Working on the Bucket List
59mEF Core 6: Fulfilling the Bucket List
43mEF Core 9: Evolving Data Access in .NET
37mBeyond Relational with Entity Framework
59mBeyond Relational With Entity Framework