Shay Rojansky - How Entity Framework translates LINQ all the way to SQL - Dotnetos Conference 2019

Visit our website to learn more! conf.dotnetos.org/
Facebook: / dotnetos
Twitter: / dotnetosorg
Shay is a senior software engineering working in Microsoft's data access team, on Entity Framework Core, the .NET database API (ADO.NET) and other stuff. He is also the lead developer of Npgsql, the .NET open source driver for the PostgreSQL database. Shay is interested in all things performance - low-level and otherwise - and works hard to make .NET
shine in various benchmarks.
Deep dive into an ORM!
.NET ORMs have a particularly complex and thankless job that few people fully understand - to translate user LINQ constructs into SQL; this talk will be a deep dive into Entity Framework's internals which handle this. We'll be discussing IQueryable providers, LINQ expression trees (which can be used to improve perf via code generation), the visitor pattern and the EF's internal architecture, some interesting and non-obvious mismatches between LINQ and SQL and how to overcome them, and some internal as well as user-facing techniques for making EF perform better. We will also focus on some aspects that make the new EF Core different from other ORMs.

[@thienan2672]

It's nice to finally have some overview of what's running under the hood of some libraries I use everyday. That's why I love Dotnetos

[@Dotnetos]

Thank you! 🔥

[@abdusco]

Always a delight to listen to Shay's talks.

[@maciejpakulski1182]

Really good presentation, thanks.

[@glob3rek]

Thanks, great presentation

[@amirhosseinahmadi3706]

Amazing presentation.

[@Dotnetos]

Thank you on behalf of Shay!

[@andeslam7370]

a really god presentation that gives a glance to what is actually happening under the hood.
thanks!

[@Dotnetos]

We're glad that you like it! 🔥

[@dotnet3070]

Great presentation, packed with helpful concept/info. Thanks for sharing.

[@Dotnetos]

And thank you for watching! Glad you liked it!