Translating LINQ to SQL: caching, nullability and other deep topics from EF's query pipeline

Have you ever asked yourself how Entity Framework Core does its magic, translating your LINQ queries all the way to SQL, and reading the results back as .NET objects?

.NET

Database

In this talk we'll dive deep into the EF pipeline, and discuss the challenges, the architecture and the solutions to some complex problems. We'll discuss performance, SQL optimization, code generation, LINQ expression trees, null semantics headaches, and various fascinating, low-level details that you've thought about when interacting with EF as a user.

Shay Rojansky

I'm in love with everything data in .NET - Entity Framework, System.Data, vector databases, and anything else that has you talking to some sort of database. I'm especially interested in making things go faster, and going deep into the guts of things in order to make that happen. I'm also one of the developers working on Npgsql, the PostgreSQL .NET provider..