Modern C# and .NET Tutorial: Cross-Platform Basics/

...

Filtering Included Entities

Learn about filtered includes in EF Core and filtering and sorting data using Entity Framework Core by creating a complex query.

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 the ...

Introduction

Hello, C#! Welcome, .NET!

Speaking C#

Controlling Flow, Converting Types, and Handling Exception

Writing, Debugging, and Testing Functions

Building Your Own Types with Object-Oriented Programming

Implementing Interfaces and Inheriting Classes

Packaging and Distributing .NET Types

Working with Common .NET Types

Working with Files, Streams, and Serialization

Working with Data Using Entity Framework Core

Querying and Manipulating Data Using LINQ

Introducing Web Development Using ASP.NET Core

Building Websites Using ASP.NET Core Razor Pages

Building Websites Using the Model-View-Controller Pattern

Building and Consuming Web Services

Building User Interfaces Using Blazor

Conclusion

Filtering Included Entities

Filtering data using `FilteredIncludes` method

Filtering Included Entities

Filtering data using FilteredIncludes method

Filtering data using `FilteredIncludes` method