Linq - find an item in nested collections

Question

I have a general list - SupportedTypeGroups.

Each supported TypeGroup has the SupportedTypes property (general list of SupportedType).

How to build a Linq query to search for SupportedType with the required name?

Answer 1

var result = SupportedTypeGroups .SelectMany(g => g.SupportedTypes) .FirstOrDefault(t => t.Name == "TypeName"); 

Answer 2

 SupportedTypeGroups .SelectMany(s => s.SupportedTypes) .Where(s => s.name == "TheName"); 

Answer 3

Assuming SupportedTypes is IEnumerable<SupportedType>

 from g in SupportedTypeGroups where g.SupportedTypes.Where(t => t.Name == "magicName") select g; 

Assuming SupportedTypes is just a SupportedType property

 from g in SupportedTypeGroups where g.SupportedTypes.Name == "magicName" select g; 

If you just want SupportedType

 from tg in SupportedTypeGroups from t in tg.SupportedTypes where t.Name == "magicName" select t;