LINQ Set Operations (Distinct, Union, Intersect, Except)

In LINQ, Set Operators are used to return result set based on the presence or absence of equivalent elements within the same or separate collections.


In LINQ we have different type of set operators available those are:


These set operators will perform different operators like removing duplicate elements from the collections or combine all the elements of collections or leave some elements from collection based on our requirements.


Following table shows more details related to set operators in LINQ.


UNION It combine multiple collections into single collection and return resultant collection with unique elements
INTERSECT It return sequence elements which are common in both the input sequences
DISTINCT It removes duplicate elements from the collection and returns collection with unique values
EXCEPT It returns sequence elements from first input sequence that are not present in second input sequence

In coming chapters we will more about each set operator in detail with examples.



LINQ Group Join

Topics Covered