LINQ基础之Intersect、Except和Distinct子句_C#教程

var q =  (from c in db.Customers            
          select c.Age         
         ).Intersect(             
                    from e in db.Employees             
                    select e.Age
         );

var q = (from c in db.Customers    
        select c.Name
        ).Except(from e in db.Employees     
                 select e.Name
 );

//1 2 这两条记录

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

 //1 2 3 4 这四条记录
var q2 = from s in db.Student
      where s.ID < 5
      select s;

var r = q1.Except(q2).ToList();// 空
var r2 = q2.Except(q1).ToList();//3 4

List<int> list = new List<int>() {1,2,3,3,3};
var result = list.Distinct();