linq to entity ,GROUP BY having

[net90]

SQL:
   SELECT TOP 1 min(id) BAGID FROM A group by id having count(id)=1 ORDER BY id ASC

LINQ这么写。在网上查了很多，好像就是一篇，对着抄袭。

[q107770540]

var query=( from a in db.A
           group a by a.id into g
           where g.Count()==1
           order by g.Key
           select new {BAGID =g.Min(x=>x.id)}).FirstOrDefault();

[骑着蜗牛去爬山]

int minid = (from t in dc.Class1 group t by t.id into g where g.Count() == 1 order by g.Key select new { bagid = g.Key }).Min(t => t.bagid);

[claymore1114]

感觉 sql语句 是不是有点 问题， min 和 orderby 有重复？？ var query = db.A.GroupBy(g => g.Id).Where(w => w.Count() == 1).OrderBy(o => o.Key).FirstOrDefault(); var query1=db.A.GroupBy(g => g.Id).Where(w => w.Count() == 1).Min(m=>m.Key);

[fengyun871210]

根据id升序,取第一条本身就是最小的,所以min(id)没起到作用.