首頁(yè) 猿問(wèn) 這個(gè)SQL語(yǔ)句怎么翻譯成LINQ語(yǔ)...

這個(gè)SQL語(yǔ)句怎么翻譯成LINQ語(yǔ)句？急啊

.NET

呼喚遠(yuǎn)方 2018-08-22 09:06:49

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新人，希望各位高手解答，謝謝

查看完整描述

2 回答

aluckdog

TA貢獻(xiàn)1847條經(jīng)驗(yàn) 獲得超7個(gè)贊

AllotDetail dbdinner join這里是不是錯(cuò)了?

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)
            });

反對(duì) 回復(fù) 2018-08-27

慕沐林林

TA貢獻(xiàn)2016條經(jīng)驗(yàn) 獲得超9個(gè)贊

大概這么個(gè)意思，照著你的sql手寫(xiě)的，寫(xiě)錯(cuò)了就自己改改:

　　　　　　　　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)
                        }