Lamdba表达式求解，一对多关系用groupjoin取多的最后一条

[u012142234]

有2个表 A表 B表
A表中id 对应 B表中Aid
A表
ID Name
1 xxx

B表
id Aid Name
1 1 aaa
2 1 bbb
3 1 ccc

求解用lambda表达式，groupjoin取出ccc的那一条

[q107770540]

var query = from a in db.A
            join b in db.B on q.id equals b.Aid into g
            select g.OrderByDescending(x=>x.id).First();

[u012142234]

是不是 没表达清楚。。。 就是两表关联 但是是一对多的关系 关联后 取数据多的表里 关联项

[蓝_ls]

如果是升序 var query = from a in A join b in B on a.id equals b.Aid select new { b.id, b.Name }; var query1 = query.Where(a => a.Name== "ccc").OrderBy(a=>a.ID).First(); 如果是降序 var query = from a in A join b in B on a.id equals b.Aid select new { b.id, b.Name }; var query1 = query.Where(a => a.Name== "ccc").OrderByDescending(a=>a.ID).First();

[qq307269906]

var result = from a in db.A join b in db.B on q.id equals b.Aid into g select g.OrderByDescending(x=>x.id).FirstOrDefault();