chapter eight

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, in that the focus is 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 Create and apply a migration

8.3 Querying data

8.3.1 Retrieving multiple records

8.3.2 Selecting single records

8.4 Scaffolding CRUD pages

8.4.1 Visual Studio scaffold instructions

8.4.2 Scaffolding from the command line

8.4.3 Working with the scaffolded pages

8.5 Creating, modifying, and deleting data

8.5.1 Modifying Data

8.5.2 Deleting data

8.6 Summary