Chapter 5. Querying the database

2.1 Setting the scene—our book-selling site

2.1.1 The book app’s relational database

2.1.2 Other relationship types not covered in this chapter

2.1.3 The final database showing all the tables

2.1.4 The classes that EF Core maps to the database

2.2 Creating the application’s DbContext

2.2.1 Defining the application’s DbContext: EfCoreContext

2.2.2 Creating an instance of the application’s DbContext

2.2.3 Creating a database for your own application

2.3 Understanding database queries

2.3.1 Application’s DbContext property access

2.3.2 A series of LINQ/EF Core commands

2.3.3 The execute command

2.4 Loading related data

2.4.1 Eager loading: loading relationships with the primary entity class

2.4.2 Explicit loading: loading relationships after the primary entity class

2.4.3 Select loading: loading specific parts of primary entity class and any relationships

2.5 Using client vs. server evaluation: moving part of your query into software

2.5.1 Creating the display string of a book’s authors

2.5.2 Understanding the limitations of client vs. server evaluation

2.6 Building complex queries

2.6.1 Building the book list query by using select loading

2.6.2 Introducing the architecture of the book app

2.7 Adding sorting, filtering, and paging

2.7.1 Sorting books by price, publication date, and customer ratings

2.7.2 Filtering books by publication year and customer ratings

2.7.3 Paging the books in the list

2.8 Putting it all together: combining query objects

Summary