The trick with EF Core is to let it do the simple stuff and if you need anything more complicated than .Include write the query yourself.