Return the Set Union of Two Sequences
Use the Union operator to return the set union of two sequences.
This example uses Union to return a sequence of all countries in which there are either
var infoQuery = (from cust in db.Customers select cust.Country) .Union (from emp in db.Employees select emp.Country) ;
In LINQ to SQL, the Union operator is defined for multisets as the unordered concatenation of the multisets (effectively the result of the UNION ALL clause in SQL).
Copyright © 2012 by Microsoft Corporation. All rights reserved.