In the past, I have used joins to achieve comparable results. For instance, I have accounts with nested addresses (1:M). I would use joins like shown below if I wanted to obtain, example, all the accounts that are associated with a specific nation....(from a in accountRepo.GetAll()
join aa in accountAddressRepo.GetAll() on a.AccountId equals ...
In EF Core, I succeeded in doing this. I'm very certain that EF6 uses the same idea....Simplifying your illustration:...var item = ctx.Order.Include("Inner")
.Where(x => x.Inner.Any(innerItem => innerItem.IsDeleted))