Entity Framework 4.0 Recipes: A Problem-Solution Approach

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.

Figure 13.1. A simple Table per ...