把SQL语句翻译成linq

[u010096351]

SELECT to_char(nvl(SUM(HuOutDtl.DrugNum),0)) AS SaleNum

FROM HuOut INNER JOIN HuOutDtl ON HuOut.ID = HuOutDtl.BillId

WHERE HuOut.HouseId=1 AND months_between(trunc(sysdate,''month''),trunc(HuOut.SignTime,''month''))


如题，把SQL语句写成linq形式，本人对linq的知识不怎么熟悉，亲，会的就帮个忙

[gxingmin]

不太明白oracle的months_between函数，是不是判断前者比后者小？ 试试下面这个

var SaleNum = (from q in db.HuOut
            join d in db.HuOutDtl on q.ID equals d.BillId
            where q.HouseId=1 && d.SignTime.Month > DateTime.Now.Month
            select d.DrugNum).DefaultIfEmpty(0).Sum().ToString();

[u010096351]

非常感谢亲的帮忙，顺便告诉你一声，oracle的months_between(x,y)函数就比如是计算xy之间有几个月

[gxingmin]

这样好么？！