O'Reilly logo

Entity Framework Core Cookbook - Second Edition by Ricardo Peres

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Improving the performance of queries

We want to get the best performance that we can, from the code/application side of things. When it comes to relational databases, we are interested in optimizing the following:

  • Modifications (inserts, updates, deletes)
  • Queries

Each has a different solution.

Getting ready

We will be using the NuGet Package Manager to install the Entity Framework Core 1 package, Microsoft.EntityFrameworkCore. We will also be using a SQL Server database to store the data, so we will also need Microsoft.EntityFrameworkCore.SqlServer. We will also need Pomelo.EntityFrameworkCore.Lolita.SqlServer for the strongly typed bulk API.

Open Using EF Core Solution from the included source code examples.

Execute the database setup script from the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required