Entity Framework 6 Recipes, Second Edition

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 or to the model, or even pushing startup overhead to a different part of application, can significantly improve some aspect of your application’s performance.

13-1. 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 that you have a simple Table per Type inheritance model, like the one shown in Figure 13-1.

Figure 13-1 ...