Need a linq to objects query for a nested collection

Question

I am trying to select text from a collection that is three of four deep.

RootObject has a List<ResourceSet> resourceSets

The resourceSets has a List<Resources> resources

The resources has a List<RouteLeg> routeLegs

The routLegs has a List<ItineraryItem> itineraryItems

The each routeLeg contains and object called ItineraryItem and in that object there is a text property.

I am trying to pull out a list of all the text properties on the routeLeg object. As you can see it is nested pretty deep. I can obviously do this in nested loops..(as shown below) but want something cleaner using Linq to Objects but I am having trouble with the multiple nesting.

  ResourceSet testst = new ResourceSet();
            ResourceSet rs;          
            StringBuilder sb = new StringBuilder();

            for (int i = 0; i < _Result.resourceSets.Count; i++)
            {
                rs = _Result.resourceSets[i];


                for (int j = 0; j < rs.resources.Count; i++)
                {

                    Resource rec = rs.resources[j];

                    string test = rec.distanceUnit;

                    for (int k = 0; k < rec.routeLegs.Count; k++)
                    {
                        RouteLeg rl = rec.routeLegs[k];

                        for (int l = 0; l < rl.itineraryItems.Count; l++)
                        {
                            ItineraryItem ii = rl.itineraryItems[l];                           
                            sb.Append(ii.instruction.ToString());
                        }
                    }

                }
            }

You have a bug... for (int j = 0; j < rs.resources.Count; i++) should be for (int j = 0; j < rs.resources.Count; j++) (you used i instead of j) — Matthew Whited
– Matthew Whited, Commented Sep 11, 2017 at 20:38

Reed Copsey · Accepted Answer · 2017-09-11 22:53:54Z

13

You can use SelectMany to fetch the internal items:

var items = result.resourceSets
                  .SelectMany(rs => rs.resources)
                  .SelectMany(res => res.routeLegs)
                  .SelectMany(rl => rl.itineraryItems)
foreach(var x in items)
    sb.Append(x.instruction.ToString());

edited Sep 11, 2017 at 22:53

answered Jan 22, 2013 at 19:36

Reed Copsey

567k80 gold badges1.2k silver badges1.4k bronze badges

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

1 Comment

pgee70 Over a year ago

should the last line be sb.Append(item.instruction.ToString()); ?

Collectives™ on Stack Overflow

Need a linq to objects query for a nested collection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related