How to: Return the Set Difference Between Two Sequences (LINQ to SQL)
Use the Except operator to return the set difference between two sequences.
This example uses Except to return a sequence of all countries in which Customers live but in which no Employees live.
In LINQ to SQL, the Except operation is well defined only on sets. The semantics for multisets is undefined.