LINQ C# include nested entities

Question

I got following structure:

Class A has a member: List<ClassB>

Class B has a member: List<ClassC>

Who is it possible to get for one specific object of class A one specific object of List<B> and all of it's objects in List<ClassC>?

In a other way: How can I get the List<ClassC> for a specific ClassB?

Possible duplicate of Difference Between Select and SelectMany — GSerg
– GSerg, Commented Apr 5, 2017 at 17:50
Are you using EF and are those classes entities of your model? How do you know which ClassB object you want to get? — ocuenca
– ocuenca, Commented Apr 5, 2017 at 17:51

msitt · Accepted Answer · 2017-04-05 17:54:51Z

1

Try:

var a_list = new List<A>();
var c_list = a_list.First(a => [your criteria here])
                   .b_list
                   .First(b => [your criteria here])
                   .c_list;

edited Apr 5, 2017 at 17:54

msitt

1,23713 silver badges27 bronze badges

answered Apr 5, 2017 at 17:51

steliosbl

8,9275 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ranjith V · Accepted Answer · 2017-04-05 18:23:08Z

0

You can try ( to avoid any exceptions)

 ClassA classAItem = yourClassAList.FirstOrDefault({your A condition})

    if(classAItem != null)
    {
      ClassB  classBItem = classAItem.yourClassBList.FirstOrDefault({your B condition});

      if(classBItem != null)
      {
        List<ClassC> classCItem = classBItem.yourClassCList);
      }
}

edited Apr 5, 2017 at 18:23

answered Apr 5, 2017 at 17:59

Ranjith V

3081 gold badge3 silver badges16 bronze badges

Comments

sampa · Accepted Answer · 2017-04-06 08:15:04Z

0

Found the solution:

_db.ClassA.Include(b => b.ClassB).ThenInclude(c => c.ClassC);

Thanks for your answers!

answered Apr 6, 2017 at 8:15

sampa

6691 gold badge7 silver badges35 bronze badges

Collectives™ on Stack Overflow

LINQ C# include nested entities

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related