Return the Set Union of Two Sequences

Return the Set Union of Two Sequences

 

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

Example

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)
    .Union
        (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).

Show:
© 2016 Microsoft