Filtering Included Entities

Explore filtering included entities in Entity Framework Core by using lambda expressions in includes. Learn to write queries that filter and sort data based on user input, and understand best practices to efficiently retrieve and display relevant database records.

We'll cover the following...

Filtering data using FilteredIncludes method
- Try it yourself
Filtering and sorting data
- Try it yourself

Filtering data using `FilteredIncludes` method

EF Core 5 introduced filtered includes, which means we can specify a lambda expression in the Include method call to filter which entities are returned in the results:

Step 1: In Program.Queries.cs, define a FilteredIncludes method, and add statements to do these tasks, as shown in the following code:

Create an instance of the Northwind class that will manage the database.
Prompt the user to enter a minimum value for units in stock.
Create a query for categories with products with that minimum number of units in stock.
Enumerate through ...

1.Introduction

2.Hello, C#! Welcome, .NET!

3.Speaking C#

4.Controlling Flow, Converting Types, and Handling Exception

5.Writing, Debugging, and Testing Functions

6.Building Your Own Types with Object-Oriented Programming

7.Implementing Interfaces and Inheriting Classes

8.Packaging and Distributing .NET Types

9.Working with Common .NET Types

10.Working with Files, Streams, and Serialization

11.Working with Data Using Entity Framework Core

12.Querying and Manipulating Data Using LINQ

13.Introducing Web Development Using ASP.NET Core

14.Building Websites Using ASP.NET Core Razor Pages

15.Building Websites Using the Model-View-Controller Pattern

16.Building and Consuming Web Services

17.Building User Interfaces Using Blazor

18.Conclusion

Filtering Included Entities

Filtering data using `FilteredIncludes` method

Filtering Included Entities

Filtering data using FilteredIncludes method

Filtering data using `FilteredIncludes` method