~/talk

EF Core 9: Evolving Data Access in .NET

Talkat Microsoft Build 2024 · 2024-05-21..05-23· [databases, dotnet]
links:none on file
slides:none on file

EF Core 9 demonstrates concrete capabilities: it maps lists as embedded JSON mapping on Azure SQL and native arrays on PostgreSQL, emits SQL or MQL per provider, and the MongoDB.EntityFrameworkCore provider translates LINQ to Mongo query language, logs aggregate pipelines, creates indexes via the C# driver, and issues partial updates (diffs) for nested documents. It also ships an experimental precompiled queries via interceptors feature that generates SQL/MQL and materializers at publish time (dynamic queries are not supported in 9).

AI-written summary · about

  1. 0:00EF Core 9 introduction
  2. 1:12EF Core purpose and patterns
  3. 4:45LINQ query translation
  4. 8:41Mapping collections
  5. 12:14Document vs relational modeling
  6. 14:24Schema evolution in docs
  7. 15:50EF Core in Aspire demo
  8. 17:16MongoDB provider setup
  9. 20:51Query logging and indexing
  10. 23:22Change tracking with MongoDB
  11. 26:36AOT and EF Core intro
  12. 27:18Native AOT benefits
  13. 29:05Query compilation pipeline
  14. 31:51Interceptors for queries
  15. 33:42Pre-compiled LINQ demo
  16. 37:53AOT limitations and future
  17. 40:00EF Core 9 summary
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.