如何从Sql转Linq

怎么从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没错,查询是否有事务加载??