怎么从Sql转Linq SELECT card,DATE,ID FROM SCORE GROUP BY CARD,DATE,ID HAVING COUNT(card)>1 ORDER BY DATE
------解决方案--------------------
C# code
var query= from s in db.SCORE
Group s by new {s.CARD,s.DATE,s.ID} into g
where g.Count()>1
order by g.Key.DATE
select new
{
g.Key.CARD,
g.Key.DATE,
g.Key.ID
};
------解决方案-------------------- linq没错,查询是否有事务加载??