Return the Set Union of Two Sequences
.NET Framework 4.5
Use the Union operator to return the set union of two sequences.
Example
This example uses Union to return a sequence of all countries in which there are either Customers or Employees.
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).
See Also
Copyright © 2012 by Microsoft Corporation. All rights reserved.
Build Date:
