C# Group By Operator: LINQUse the group keyword in a query expression. Include the System.Linq namespace.
dot net perls
Group by. A query expression can return its results as a group. With the group-by operator, we separate the results of an expression into parts. This makes some query expressions in C# programs more useful.
Example. The group-by clause comes at the end of a query expression. No select clause is required. The first part indicates what item is to be grouped. And after "by", you specify the condition that results in groups.
Next IsEven returns true or false. Some numbers are grouped in the "false" category. The rest are grouped in the "true" category.
Odd, Even
With group, we must know how to access its results. First, we use foreach to enumerate the groups themselves. On each group, we access the Key property. Finally, when we use foreach on the enumerator of the group, we get the values.
Tip More information on the foreach-loop, which evaluates IEnumerable, is available on this site.
C# program that uses group by operators
using System; using System.Linq; class Program { static void Main() { // Input array. int[] array = { 1, 2, 3, 4, 5, 6, 7, 8, 9 }; // Group elements by IsEven. var result = from element in array orderby element group element by IsEven(element); // Loop over groups. foreach (var group in result) { // Display key and its values. Console.WriteLine(group.Key); foreach (var value in group) { Console.WriteLine(value); } } } static bool IsEven(int value) { return value % 2 == 0; } }
False 1 3 5 7 9 True 2 4 6 8
Summary. The group-by clause is an alternative to the select clause in query expressions. It allows you to divide the results in any number of categories, which can simplify further logic. It can be useful for creating tree-like hierarchies.
© 2007-2021 sam allen. see site info on the changelog