Chapter 13. Improving Performance

The recipes in this chapter cover a wide range of specific ways to improve the performance of your Entity Framework applications. In many cases, simple changes to a query, changes to the model, or even pushing startup overhead to a different part of application can significantly improve some aspect of your application's performance.

Optimizing Queries in a Table per Type Inheritance Model

Problem

You want to improve the performance of a query in a model with Table per Type inheritance.

Solution

Let's say you have a simple Table per Type inheritance model like the one shown in Figure 13-1.

A simple Table per Type inheritance model for Salaried and Hourly employees

Figure 13.1. A simple Table per ...

Get Entity Framework 4.0 Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.