CSHARP

select many vs select

Select-> selecting values from a collection.
// Two foreach loops are required to iterate through the results
// because the query returns a collection of arrays.

SelectMany-> selecting values from a collection of collection i.e. nested collection.
// Only one foreach loop is required to iterate through the results 
// since query returns a one-dimensional collection.