LINQ. How to use .Include for query entities with no direct connection

Asked Sep 23 '16 at 09:14

Active Sep 23 '16 at 09:18

Viewed 79 times

I'm trying to include in one LINQ query few entities. Entity UserPrograms > Entity Training Program > Entity SetDetails by this query

return await _db.UserPrograms.Include(x => x.TrainingProgram).Where(x=> x.IsPredefined.Value).AsNoTracking().ToArrayAsync();

SetDetails has foreign key in TrainingPrograms, TrainingPrograms has foreign key in UserPrograms, so it look like I cannot include all of these entities to the same query. You may say that I might first get SetDetails and then join to UserPrograms+TrainingPrograms results, yes, but is it possible to make in one query?

edited Sep 23 '16 at 09:18

asked Sep 23 '16 at 09:14

andrey.shedko

3,128
10
61
121

4

To put it simply, `.Include(x => x.TrainingProgram.SetDetails)` includes `.Include(x => x.TrainingProgram)` and `.Include(x => x.TrainingProgram.SetDetails)` both. – Keyur PATEL Sep 23 '16 at 09:16
@KeyurPATEL, you're right. I just forgot about this option. – andrey.shedko Sep 23 '16 at 09:21
Please add this comment as answer. – andrey.shedko Sep 23 '16 at 09:21

LINQ. How to use .Include for query entities with no direct connection

0 Answers0