LINQ Aggregate Functions in C#

Back to: CSharp LINQ and Lambda Expressions Tutorial

The LINQ (Language-Integrated Query) Aggregate Functions in C# are a set of powerful tools that allow developers to perform calculations on collections of data. The five aggregate functions provided by LINQ are Sum, Min, Max, Average, and Count. In this lesson, we’ll explore each of these functions in detail, discussing their syntax, overloads, how they work, and their applications in real-world programming.

Syntax:

Each of the five aggregate functions in LINQ has its own syntax, but they all follow a similar pattern. Here’s an example of the Sum method’s syntax:

public static int Sum<TSource>(this IEnumerable<TSource> source);

This method takes one parameter:

• The source parameter, which is an IEnumerable<T> type, representing the sequence of values to calculate the sum of.

Overloads:

• There are overloads for different data types such as float, decimal, double, long, and int.

How it works:

Each of the LINQ aggregate functions works by iterating through a sequence of data and performing a specific calculation on each element. For example, the Sum function adds each element together, while the Min function finds the smallest element in the sequence.

Let’s take a look at an example to understand how these functions work:

int[] numbers = { 5, 2, 8, 1, 9 };
int sum = numbers.Sum();
int min = numbers.Min();
int max = numbers.Max();
double average = numbers.Average();
int count = numbers.Count();

In this example, we have an array of integers named numbers. We use each of the five aggregate functions to perform a specific calculation on this array. The Sum function adds each element together and returns the total, while the Min function finds the smallest element and returns it. The Max function finds the largest element and returns it. The Average function calculates the average of all the elements in the array, while the Count function returns the total number of elements in the array.

Applications:

The LINQ aggregate functions are useful tools that can be used in a variety of real-world programming applications. For example, they can be used to calculate the total price of items in a shopping cart, the smallest and largest values in a dataset, the average score of a group of students, or the total number of records in a database table.

Conclusion:

The LINQ Aggregate Functions in C# are a powerful set of tools that allow developers to perform calculations on collections of data. Their simple syntax and wide range of applications make them a useful tool in a variety of programming scenarios. Whether you’re a beginner or an experienced programmer, understanding the LINQ Aggregate Functions can help you write more efficient and effective code.