Select and SelectMany in LINQ

Introduction

Language Integrated Query (LINQ) is a Microsoft .NET technology that provides a unified, convenient method to access and manipulate data from various sources. Select and SelectMany are two of the most commonly used LINQ query operators that allow you to extract specific data from a collection.

Select in LINQ

The Select operator in LINQ is used to project a collection into a new form. It allows you to extract data from a collection and transform it into a new set of values that meet specific requirements. The Select operator returns an IEnumerable<TResult> sequence, where TResult is the type of the elements in the resulting collection.

c#
var numbers = new List<int> { 1, 2, 3, 4, 5 };
var result = numbers.Select(x => x * 2); 
foreach (var item in result)
{
    Console.WriteLine(item);
}

Output:

2
4 
6 
8 
10

The code above creates a list of numbers and uses the Select operator to return a new collection with each element multiplied by 2.

SelectMany in LINQ

The SelectMany operator in LINQ is used to flatten a collection of collections into a single collection. It is particularly useful when you have a collection of collections and you want to extract the elements from the inner collections and combine them into a single result.

c#
var collections = new List<List<int>> 
{ 
new List<int> { 1, 2, 3 }, 
new List<int> { 4, 5, 6 }, 
new List<int> { 7, 8, 9 } 
}; 
var result = collections.SelectMany(x => x);
foreach (var item in result) 
{ 
 Console.WriteLine(item); 
}

Output:

1 
2 
3 
4 
5 
6 
7 
8 
9

The code above creates a list of lists and uses the SelectMany operator to flatten the inner lists into a single collection.

Conclusion

The Select and SelectMany operators are two of the most commonly used LINQ query operators for transforming and flattening collections. They are both powerful and flexible and can be used in a variety of ways to extract and manipulate data.