Open In App
Related Articles

Aggregation Function in LINQ

Improve Article
Improve
Save Article
Save
Like Article
Like

In LINQ, aggregation functions are those functions which are used to calculate a single value from the collection of the values. Real life example of aggregation function is calculating the annual rainfall occurred in 2018 according to readings collected whole year. Another example, the sum function is used to find the sum of the values present in the given array or sequence.

Following is the list of the methods that are used to perform aggregation operations:

MethodDescription
AggregateIt performs, a custom aggregation operation on the values of a collection.
AverageIt calculates the average value of a collection of values.
CountIt counts the elements in a collection, optionally only those elements that satisfy a predicate function.
LongCountIt counts the elements in a large collection, optionally only those elements that satisfy a predicate function.
MaxIt determines the maximum value in a collection.
MinIt determines the minimum value in a collection.
SumIt calculates the sum of the values in a collection.

Example 1:




// C# program to illustrate how to
// find the sum of the given sequence
using System;
using System.Linq;
  
public class GFG {
  
    // Main Method
    static public void Main()
    {
  
        int[] sequence = {20, 40, 50, 68, 90, 
                          89, 99, 9, 57, 69};
  
        Console.WriteLine("The sum of the given sequence is: ");
  
        // Finding sum of the given sequence
        // Using Sum function
        int result = sequence.Sum();
        Console.WriteLine(result);
    }
}

Output:

The sum of the given sequence is: 
591

Example 2:




// C# program to illustrate how to 
// find the minimum and maximum value
// from the given sequence
using System;
using System.Linq;
  
public class GFG {
  
    // Main Method
    static public void Main()
    {
  
        int[] sequence = {201, 39, 50, 9, 7, 99};
  
        // Display the Sequence
        Console.WriteLine("Sequence is: ");
  
        foreach(int s in sequence)
        {
            Console.WriteLine(s);
        }
  
        // Finding the minimum value
        // from the given sequence
        // Using Min function
        int result1 = sequence.Min();
  
        Console.WriteLine("Minimum Value is: {0}", result1);
  
        // Finding the maximum value 
        // from the given sequence
        // Using Max function
        int result2 = sequence.Max();
  
        Console.WriteLine("Maximum Value is: {0}", result2);
    }
}

Output:

Sequence is: 
201
39
50
9
7
99
Minimum Value is: 7
Maximum Value is: 201

Reference:


Last Updated : 26 May, 2019
Like Article
Save Article
Similar Reads