How does EF Core query translation work under the hood?

Updated Apr 28, 2026

Short answer

EF Core translates C# expression trees into native SQL queries using an internal Query Pipeline.

Parsing: The LINQ query is converted into an Expression Tree. 2. Preprocessing: Method calls and closures are resolved. 3. Compilation: The provider's Query Translator traverses the tree, converting abstract expressions (like .Where()) into a relational SQL AST (Abstract Syntax Tree). 4. Execution: The SQL is generated, executed via ADO.NET, and the Data Reader results are materialized back into C# objects.

Unlock with a Pro subscription to view this section.