How Entity Framework translates LINQ all the way to SQL
summary
Deep dive into how Entity Framework Core converts LINQ expression trees into SQL by running a pipeline of visitors that rewrite nodes (null semantics, instance equality, composite keys, subquery duplication) into a SQL-specific expression model and then emit SQL plus a shaper. The pipeline does parameter extraction to punch holes for caching, avoids client eval in EF Core 3 except top projections, and offers compiled queries to bypass cache overhead; pay attention to joins versus multiple queries and prepared-statement benefits.
AI-written summary · about
chapters (6)
- 0:00Start
- 6:37EXPRESSION TREES
- 22:27RELATED INSTANCES
- 34:55EF CORE PREPROCESSOR
- 42:34ZOOM OUT AGAIN
- 44:02COMPILED QUERIES
related talks
01h 00mGetting the best out of Entity Framework Core
51mUsing C# Expression Trees in the Real World
56mEntity Framework debugging using SQL Server: A Detective Story
01h 01m10 things you didn't know EF Core can do
59m10 things you didn't know EF Core can do
46mEntity Framework Core 2.1 – what’s new?
43mEF Core 9: Evolving Data Access in .NET
01h 01mEntity Framework Core Unchained Getting the Best Performance from Your ORM