EF: Include with where clause [duplicate]
This feature has now been added to Entity Framework core 5. For earlier versions you need a work-around (note that EF6 is an earlier version). Entity Framework 6 work-around In EF6, a work-around is to first query the required objects in a projection (new) and let relationship fixup do its job. You can query the … Read more