日期:2014-05-20  浏览次数:20833 次

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