Using set operation in LINQ

Posted by vik20000in on ASP.net Weblogs See other posts from ASP.net Weblogs or by vik20000in
Published on Wed, 14 Apr 2010 03:22:00 GMT Indexed on 2010/04/14 3:33 UTC
Read the original article Hit count: 474

Filed under:
|
|
|

There are many set operation that are required to be performed while working with any kind of data. This can be done very easily with the help of LINQ methods available for this functionality. Below are some of the examples of the set operation with LINQ.

Finding distinct values in the set of data.

We can use the distinct method to find out distinct values in a given list.

    int[] factorsOf300 = { 2, 2, 3, 5, 5 };

    var uniqueFactors = factorsOf300.Distinct();

We can also use the set operation of UNION with the help of UNION method in the LINQ. The Union method takes another collection as a parameter and returns the distinct union values in  both the list. Below is an example.

    int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };
    int[] numbersB = { 1, 3, 5, 7, 8 };
    var uniqueNumbers = numbersA.Union(numbersB);

We can also get the set operation of INTERSECT with the help of the INTERSECT method. Below is an example.

    int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };

    int[] numbersB = { 1, 3, 5, 7, 8 };

   

    var commonNumbers = numbersA.Intersect(numbersB);

 

We can also find the difference between the 2 sets of data with the help of except method.

 

    int[] numbersA = { 0, 2, 4, 5, 6, 8, 9 };

    int[] numbersB = { 1, 3, 5, 7, 8 };

   

    IEnumerable<int> aOnlyNumbers = numbersA.Except(numbersB);

 

Vikram

© ASP.net Weblogs or respective owner

Related posts about .NET

Related posts about ASP.NET