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)
Each has a different solution.
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 ...