Over a million developers have joined DZone.

Fun with LINQ Aggregate

DZone's Guide to

Fun with LINQ Aggregate

Free Resource

Say we’ve got a CSV file:

private const string csv = 

We want to parse it into nested List<int>, and then print out all the numbers on a single line. We might do it like this:

public void ParseCsvAndOutputAsString()
var data = new List<List<int>>();

foreach (var line in csv.Split('\n'))
var innerList = new List<int>();
foreach (var item in line.Split(','))

string output = "";
foreach (var innerList in data)
foreach (var item in innerList)
output = string.Format("{0} {1}", output, item);


Yes, I know I should use a StringBuilder and AddRange, but ignore that for the moment, I’m trying to make a point here.

Taking a collection of values and reducing them down to a single value is a very common task in programming. Here we’re doing it twice; first we’re taking a string, splitting it apart and then reducing it down to a single reference to a List<List<int>>; then we’re taking the may items of data and reducing them to a string.

This is so common in fact, that many programming languages have some kind of ‘reduce’ functionality built in. It’s especially common with functional languages. Did you know that C# also has a reduce function? It’s the Aggregate extension method. Here’s the same method written in two statements with it:

public void ParseCsvAndOutputAsStringUsingAgregate()
var data = csv
new List<List<int>>(),
(list, line) => list.Append(line
.Select(str => int.Parse(str))
new List<int>(),
(innerList, item) => innerList.Append(item))));

.SelectMany(innerList => innerList)
.Aggregate("", (output, item) => string.Format("{0} {1}", output, item)));

Aggregate takes two parameters; the first sets up the initial value, in our case we create new instances of List<List<int>>, List<int> and an empty string, this is known as the ‘accumulator’; the second is the function that does the accumulating.

Aggregate works really well with fluent interfaces, where methods return their instance. I’ve added a fluent ‘Append’ extension method to List<int> to help me here:

public static List<T> Append<T>(this List<T> list, T item)
return list;

So any time you’ve got a collection of stuff that you want to ‘reduce’ to a single item, remember Aggregate.



Published at DZone with permission of Mike Hadlow, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}