Union,Except and Intersect operator in Linq
Posted
by Jalpesh P. Vadgama
on ASP.net Weblogs
See other posts from ASP.net Weblogs
or by Jalpesh P. Vadgama
Published on Thu, 17 Jun 2010 20:14:28 GMT
Indexed on
2010/06/17
20:24 UTC
Read the original article
Hit count: 467
While developing a windows service using Linq-To-SQL i was in need of something that will intersect the two list and return a list with the result. After searching on net i have found three great use full operators in Linq Union,Except and Intersect. Here are explanation of each operator.
Union Operator: Union operator will combine elements of both entity and return result as third new entities.
Except Operator: Except operator will remove elements of first entities which elements are there in second entities and will return as third new entities.
Intersect Operator: As name suggest it will return common elements of both entities and return result as new entities.
Let’s take a simple console application as a example where i have used two string array and applied the three operator one by one and print the result using Console.Writeline. Here is the code for that.
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
-
-
- namespace ConsoleApplication1
- {
- class Program
- {
- static void Main(string[] args)
- {
- string[] a = { "a", "b", "c", "d" };
- string[] b = { "d","e","f","g"};
-
- var UnResult = a.Union(b);
- Console.WriteLine("Union Result");
- foreach (string s in UnResult)
- {
- Console.WriteLine(s);
- }
-
- var ExResult = a.Except(b);
- Console.WriteLine("Except Result");
- foreach (string s in ExResult)
- {
- Console.WriteLine(s);
- }
-
- var InResult = a.Intersect(b);
- Console.WriteLine("Intersect Result");
- foreach (string s in InResult)
- {
- Console.WriteLine(s);
- }
- Console.ReadLine();
-
- }
-
- }
- }
-
Here is the output of console application as Expected.
Hope this will help you..
© ASP.net Weblogs or respective owner
