~/talk

10 things you didn't know EF Core can do

Talkat CPH DevFest 2024 · 2024-08-26..08-30· [databases]
slides:none on file

A practical checklist of 11 EF Core capabilities (one is fake): compiled queries to precompile LINQ and cut per-request parsing, SQL Server hierarchyid support via the provider package for single-roundtrip tree queries, JSON columns for nested objects instead of extra tables, raw SQL that composes with LINQ and approaches Dapper performance, many-to-many and several inheritance mappings (TPH, TPT, TPC), logical deletes via shadow props and global filters, and control over batching; first live demo fails then subsequent demos run successfully; EF Core 8+ is the era referenced.

AI-written summary · about

  1. 0:00Introduction
  2. 3:19EF Core hidden features
  3. 18:53Feature voting
  4. 21:14Live compiled queries
  5. 33:39Hierarchy IDs
  6. 45:26JSON columns
  7. 52:16Raw SQL queries
  8. 59:29Summary
~/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.