As much as DBAs and other data professionals hope, Entity Frameworks isn’t going away. I’ve heard so many complaints about how slow Entity Framework is or how poorly the SQL that Entity Framework generates but what’s really missing is an understanding of what Entity Framework is, how it boosts developer productivity, and how we can make it better. This presentation gives an overview on what is Entity Framework, how it works, and why developers prefer it. The second half of the presentation is spent investigating some common problems with Entity Framework and SQL Server such as database generation gotchas, the dreaded N + 1 problem, and how Entity Framework can slay indexes. Plus a few other Entity Framework performance tips. This is a session that I love to give it gives the data professional a good understanding of what Entity Framework is and what they can do to improve performance.

Abstract

Entity Framework and other Object Relational Mapping technologies have been a boon for developers but how do they really affect the database? More importantly is Entity Framework a technology that developers should even be using? In this session, we’ll review what Entity Framework is and how it’s changed over time. We’ll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we’ll review T-SQL generated by Entity Framework and give some tips on how to improve performance.

Demos

You can find the demos on GitHub under the Demo.EFDataProfessionals repo or download the .zip directly.

Slides

Leave a Reply