Linq語法

1.內連接

var list=from a in aaaaaaa
         join b in bbbbbbb on a.ID equals b.ID where a.sex="男"
         select new { a.name,b.age }

2.左連接

var list = from a in aaaaa
           join b in bbbbb on a.ID equals b.ID into g
           from b in g.DefaultIfEmpty() where a.sex="男"
           select new { a.name,b.age}

3.分組查詢

var list = from a in aaaaa
           join b in bbbbb on a.ID equals b.ID into g where a.sex="男"
           select new { a.name,b.age }

4.linq語法出現a.age==list[i],報錯System.NotSupportedException:“LINQ to Entities does not recognize the method 'System.Object get_Item(System.String)' method, and this method cannot be translated into a store ，是因為linq不支持數組，可以修改一下就可以

//會報錯，linq並不支持
var query = user.Where(x=>x.age==list[i]).toList();


//修改後
var list=list[i];
var query = user.Where(x=>x.age==list).toList();