AI, Data, and Machine Learning

W06 Entity Framework Performance Monitoring and Tuning

06/15/2022

9:30am - 10:45am

Level: Intermediate to Advanced

Jim Wooley

Senior Delivery Principal

Slalom Consulting

Object Relational Mapping technologies, including the Entity Framework can drastically simplify the programming model against databases, but when done carelessly, performance can suffer. In this session, we'll explore some real-life strategies that have solved performance issues in production applications that I have encountered at a variety of customers. We'll discuss the pros and cons of working without stored procs and cover strategies for monitoring and tuning your entity queries.

You will learn:

  • Discover how to profile your database interactions through Entity Framework
  • Discover typical performance issues based on real-life examples and how to fix them
  • Learn how different versions of EF generate different queries and how you need to modify your data access strategy as a result