这个SQL语句怎么翻译成LINQ语句？急啊

Question

select dbd.AllotRecID, dbd.ProductID, sum(rec.Weight) weight from AllotDetail dbdinner join OutputRec recon dbd.AllotRecID = rec.AllotRecID and dbd.ProductID = rec.ProductID group by dbd.AllotRecID, dbd.ProductID, dbd.Weighthaving dbd.Weight > sum(rec.Weight)

本人LINQ新人，希望各位高手解答，谢谢

Answer 1

AllotDetail dbdinner join这里是不是错了?AllotDetail dbd inner join?? var result = ctx.AllotDetail.GroupJoin                (                ctx.OutputRec,                a => a.AllotRecID,                o => o.AllotRectID,                (a, c) =>            new            {                ProductID = a.ProductID,                Weight = c.Sum(s => s.Weight)            });

Answer 2

大概这么个意思，照着你的sql手写的，写错了就自己改改:　　　　　　　　from p in AllotDetail                        from q in OutputRec                        group p by p.AllotRecID,p.ProductID,p.Weight into g                        where g.Weight > weight                        select new {                            AllotRecID,ProductID,                            weight = g.Sum(p => p.Weight)                        }