Return the Set Union of Two Sequences


Use the Union<TSource> operator to return the set union of two sequences.


This example uses Union<TSource> 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)
        (from emp in db.Employees
        select emp.Country)

In LINQ to SQL, the Union<TSource> operator is defined for multisets as the unordered concatenation of the multisets (effectively the result of the UNION ALL clause in SQL).