Entity Framework - Include 3 sublevels of properties

Question

I'm using EF6 Code-First. I have four-leveled entities with the following hierarchy:

Express(top level) 
    -> Constant(1st sublevel) 
    -> Event(also 1st sublevel) 
         -> Parameter(2nd sublevel) 
              -> Value(3rd sublevel)

I can obtain 2 sublevels via

db.Expresses.Include(ex=>ex.Constants).Include(ex=>ex.Events.Select(ev=>ev.Parameters));

But how can I include third sublevel (Value) in that query?

Possible duplicate of [EF LINQ include multiple and nested entities](https://stackoverflow.com/questions/15764572/ef-linq-include-multiple-and-nested-entities) — CodeNotFound, Nov 20 '18 at 08:56

score 1 · Accepted Answer · edited Nov 20 '18 at 08:54

1

db.Expresses.Include(ex => ex.Constants)
            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));

Please ensure using System.Data.Entity namespace to get the overrides of Include method. See this link for more examples.

edited Nov 20 '18 at 08:54

CodeNotFound

18,731
6
54
63

answered Nov 20 '18 at 08:48

Ayberk

502
2
11

Oh, that was so easy :) Thx. – bairog Nov 20 '18 at 08:54

score 0 · Answer 2 · answered Nov 24 '18 at 15:01

0

An alternative is to use strings

db.Expresses.Include("Constants")
            .Include("Events.Parameters.Values")

answered Nov 24 '18 at 15:01

Leo

7,061
6
26
43

Entity Framework - Include 3 sublevels of properties

2 Answers2