LINQ基础之Join和UNION子句

var innerJoinQuery =
              from cateGory in categories
              join prod in products on category.ID equals prod.CategoryID
                      select new { ProductName = prod.Name, Category = category.Name };

var innerGroupJoinQuery =
 from category in categories
 join prod in products on category.ID equals prod.CategoryID
 into prodGroup
 select new { CategoryName = category.Name, Products = prodGroup };

var leftOuterJoinQuery =
             from category in categories
             join prod in products on category.ID equals prod.CategoryID
             into prodGroup
                     from item in prodGroup.DefaultIfEmpty(new Product{Name =
             string.Empty, CategoryID = 0})
                     select new { CatName = category.Name, ProdName = item.Name };

var q = (from c in db.Customers
         select c.Country
           ).Union(from e in db.Employees
                   select e.Country
           );

var q1 = from s in db.Student
                        where s.ID < 3
                        select s;
var q2 = from s in db.Student
                        where s.ID < 5
                        select s;

 //去掉重复的
var q = q1.Union(q2);
var r = q.ToList();//ToList之后，会把数据查出来在内存中操作

//Concat不会去除重复项目，相当于SQL的Union All；
//不去掉重复的 相当于union all，
var q3 = q1.Concat(q2);
var r3 = q3.ToList()

var q = db.Customers.Union(db.Employees).select(d=>d.Country);