How to include multiple child into Query?

Question

I have table A, B , C, D, E, F with the relationship
A(parent) --> B ---> C (Part A) A(parent) --> D --> E -- > F (Part B)

I'd refer the link below to get my answer but I am only able to get till E part B. I couldn't get until F

Click here!

Here is my code:

var query = db.tableA.Include(c => c.tableB.Select(b => b.tableC))                                                                                 
           .Include(d => d.tableD.Select(e => e.tableE));

As I understand `tableE` has relationship with `tableF` and you cannot include it. Am I right? If so, what is type of relationsip? *one-to-one*, *one-to-many* or something else? — Adil Mammadov, Sep 01 '16 at 10:28
Yes. I don't know how to include tableF. E-F (1 to many). F can be nullable. — Brian Lee, Sep 01 '16 at 10:37
just change second line in your code to `.Include(d => d.tableD.Select(e => e.tableE.Select(m => m.tableF)));`. It should help — Adil Mammadov, Sep 01 '16 at 10:39

score 0 · Accepted Answer · answered Sep 01 '16 at 12:30

It one tableE can have collection of tableF then you just need to add another select:

var query = db.tableA.Include(c => c.tableB.Select(b => b.tableC))
        .Include(d => d.tableD.Select(e => e.tableE.Select(m => m.tableF)));

If one tableE can have one tableF then you should write it as below:

var query = db.tableA.Include(c => c.tableB.Select(b => b.tableC))
        .Include(d => d.tableD.Select(e => e.tableE.tableF));

How to include multiple child into Query?

1 Answers1