Jorriss.com

Who’s Afraid of Entity Framework?

Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn’t self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it’s changed over time. We’ll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we’ll review EF-generated T-SQL and give some tips on how to improve performance. If you’re a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

Demo code is available on Github.

Richie Rump

// about the author

Richie Rump is a Dataveloper.

Richie Rump is a principal software engineer and software architect with more than two decades spent at the intersection of application code and the data layer. He builds and operates data-intensive products, including database diagnostic tools, cloud-native serverless platforms, and full-stack applications, owning them from architecture and database design all the way through to production. Beyond the day job, he created StatisticsParser.com, co-founded a user group, and co-hosted the Away From The Keyboard podcast. On this site, he writes about performance, database internals, and the engineering practices behind reliable systems.