Filtering "include" entities in EF Core

Entity Framework Core include filter

ZZZ_tmp

Entity Framework Core Include with Filter

ZZZ_tmp

Filtering on Include in EF Core

ZZZ_tmp

EF Core include an ICollection<T> with a filter on the collection's referenced object

ZZZ_tmp

EF Core Select one Entity filtered by related entities

So disregard SQL and joins. You may retrieve related data in EF (Core) targeting LINQ queries by using the navigation properties. Entities in the context of the query stand in for database table records, joins, and linked table records....You utilize simple criteria for reference navigation characteristics, such as:...Where(entity => entity.Referen...

Entity Framework Core: Global query filter not filtering correctly after data change

ZZZ_tmp

Entity Framework Core 3.0 new features - filtered include

ZZZ_tmp

Include Filters for Entity Framework Core

ZZZ_tmp

Entity Framework Core .Include() is filtering the query

ZZZ_tmp

Automapper Entity Framework Core Include Filter Mapping Issue

ZZZ_tmp