~/talk

EF Core 8 overview and demo

Talkat Øredev 2023 · 2023-11-08..11-10· [databases]
slides:none on file

Demo shows EF Core 8 shipping concrete work not promises: primitive collections as JSON stored in a column and queried via openjson table expansion (requires SQL Server compatibility level 130), raw SQL can materialize unmapped types, DateOnly/TimeOnly get native mapping, EF Core 8 requires .NET 8 and is an LTS release, savechanges reduces round trips yielding roughly ~40% save changes improvement, and a new Woodstar driver preview plus built‑in Visual Studio tooling appear as slides and demos.

AI-written summary · about

  1. 0:00Introduction
  2. 1:04What is EF Core
  3. 3:35EF Core lifecycle
  4. 7:59Primitive collections in EF8
  5. 15:59Querying primitive collections
  6. 18:12Database compatibility
  7. 23:15Query cache pollution fix
  8. 25:06Raw SQL for unmapped types
  9. 27:19LINQ with raw SQL
  10. 29:04DateOnly and TimeOnly
  11. 31:38EF7/8 performance
  12. 33:09SaveChanges round trips
  13. 38:04Woodstar driver
  14. 40:16VS tooling
  15. 41:21Next steps
~/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.