Set Operators: Union : Union « LINQ « C# / CSharp Tutorial






using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

    class Customer
    {
        public string ID { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Region { get; set; }
        public decimal Sales { get; set; }
    }
    class Order
    {
        public string ID { get; set; }
        public decimal Amount { get; set; }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<Order> orders = new List<Order> {
              new Order { ID="R", Amount=900 },
              new Order { ID="S", Amount=1000 },
              new Order { ID="T", Amount=1100 }
            };
            List<Customer> customers = new List<Customer> {
              new Customer { ID="Q", City="London", Country="UK", Region="Europe", Sales=8000 },
              new Customer { ID="R", City="Beijing", Country="China", Region="Asia", Sales=9000 },
              new Customer { ID="T", City="Lima", Country="Peru", Region="South America", Sales=2002 }
           };

            var customerIDs = from c in customers select c.ID;
            var orderIDs = from o in orders select o.ID;
            var allCustomerOrderIDs = orderIDs.Union(customerIDs);
            foreach (var item in allCustomerOrderIDs)
            {
                Console.Write("{0} ", item);
            }            
        }
    }








22.20.Union
22.20.1.Create the Union query
22.20.2.Use Linq to union two arrays
22.20.3.prints the unique elements of two integer arrays
22.20.4.prints unique letters from Product and Customer names
22.20.5.Union Operator
22.20.6.Union does appends one sequence to another with duplicates removed:
22.20.7.Set Operators: Union