I love when things come up just in time for me to need them for a project that I’m involved in. Currently, I need to take a bunch of results and find only the intersection of those results. I was contemplating doing some lambdas to compare the lists, but then I was reading Pro LINQ: Language Integrated Query in C# 2008 and I found the Intersect() method. (Note: Thanks to Jeff Meyer for loaning me the book in such a timely fashion.)
The code looks like this:
using System; using System.Collections.Generic; using System.Linq; namespace Linq { class Program { static void Main(string[] args) { var listOne = new List<int>() { 1, 2, 3, 4, 5}; var listTwo = new List<int>() { 3, 4, 5, 6, 7}; var intIntersect = listOne.Intersect(listTwo); foreach (var i in intIntersect) { Console.WriteLine(i); } } } }
What is output is
3 4 5
There are two important things to note. First of all, you can use any IEnumerable to perform an Intersect. Secondly, it is important to realize that you are comparing from the first list to the second list. This isn’t important when doing an Intersect(), but lets look at another example.
using System; using System.Collections.Generic; using System.Linq; namespace Linq { class Program { static void Main(string[] args) { var listThree = new string[] { "Pete", "On", "Software" }; var listFour = new string[] { "Joel", "On", "Software" }; var stringExcept = listThree.Except(listFour); foreach (var s in stringExcept) { Console.WriteLine(s); } } } }
The output of this code is
Pete
In this example, I used a string array instead of a generic List to show that other IEnumerables could be used. When calling the Except() method, I get the unique value(s) from the first IEnumerable. Intersect() would have returned
On Software
and if I had written
var stringExcept = listFour.Except(listThree);
it would have returned
Joel
so much more care is needed when using Except() to ensure exactly which group has the unique values that you want to keep. However, there is one more thing you can do. What if you want to find every distinct value between the two lists? You would do something like the following
using System; using System.Collections.Generic; using System.Linq; namespace Linq { class Program { static void Main(string[] args) { var listThree = new string[] { "Pete", "Pete", "On", "Software" }; var listFour = new string[] { "Joel", "On", "Software", "Software" }; var uniqueStrings = listFour.Union(listThree); foreach (var s in uniqueStrings) { Console.WriteLine(s); } } } }
which returns
Joel On Software Pete
The above shows all of the unique values from the first group and any of the unique values that the second group brings to the party that the first group didn’t already have.
This is pretty powerful stuff if you have to process lists and should ensure that you are doing the most efficient operations possible. Linq is, of course, pretty exciting stuff and as I uncover more nuggets from the Pro LINQ: Language Integrated Query in C# 2008 book, I will share them here.
Ok, I’m impressed. Concise and powerful.
[…] that was a snoozefest. I was reading in the Pro LINQ book (the one that gave me this post) and I found Enumerable.Range. Do the wonders of LINQ never cease? Enumerable.Range will generate a […]