8 Working with data

This chapter covers

Understanding the value of Entity Framework Core and how it works
Managing the database schema with Entity Framework Core
Using Entity Framework Core to query and manage data
Scaffolding Razor Pages that work with Entity Framework Core and improving the output

So far we have concentrated our efforts on exploring features of the Razor Pages framework and how they work to generate HTML. This chapter takes a slight departure from that, focusing instead on a different framework known as Entity Framework Core (EF Core).

8.1 What is Entity Framework Core?

8.1.1 Why choose EF Core?

8.1.2 How does EF Core work?

8.1.3 Managing relationships

8.1.4 Installing Entity Framework Core

8.1.5 Create the context

8.1.6 Adding DbSets

8.1.7 Configuring the model

8.2 Migrations

8.2.1 Seed data

8.2.2 Adding migration tools

8.2.3 Creating and applying a migration

8.3 Querying data

8.3.1 Retrieving multiple records