Can you select all child collections of a collection of entities as a single collection?

Question

I have a collection of "ParentEntity", each one of which has a collection of "ChildEntity".

I'd like to select ALL of the ChildEntity as a single collection.

var children = from p in parents
 select p.Children;

Returns a collection of ChildEntity collections?

I'd like to get a single collection of all the Children, rather than a collection of collections.

score 10 · Accepted Answer · answered Mar 18 '13 at 05:45

10

var children=parents.SelectMany(p=>p.Children)

answered Mar 18 '13 at 05:45

2

You know, in all the years I don't think I've ever used this before! – BlueChippy Mar 18 '13 at 06:05

1 Answers1