linq sql语句写法1



select pid from list_Products where list_Products.p_type_id in 

(select p_type_id from list_P_type where parent_id=1)




转自：http://bbs.csdn.net/topics/390308649?page=1




var one = from a in list_Products 
          let t= list_P_type.Where(x=>x.parent_id == 1).Select(x=>x.p_type_id)
          where t.Contains(a.p_type_id)
          select a;




  var two = list_P_type.Where(x => x.parent_id == 1).Join(list_Products, p => p.p_type_id, p => p.p_type_id, (p_type, p_product) => p_product);

var two_linq = from ptype in list_P_type
                           from pProduct in list_Products
                           where ptype.p_type_id == pProduct.p_type_id && ptype.parent_id == 1
                           select pProduct;


//Lambda表达式
List<Products> result = list_Products.Where(c => list_P_type.Where(a => a.parent_id == 1).Select(a => a.p_type_id).Contains(c.pid)).ToList();

 //LINQ表达式
<Products> result1 = (from u in list_Products
                                      let n = list_P_type.Where(a => a.parent_id == 1).Select(b => b.p_type_id)
                                      where n.Contains(u.p_type_id)
                                      select u).ToList();