如何表示为实体框架查询
如何表示为实体框架查询
提问于 2015-04-20 01:31:27
如何将其表示为实体框架查询语法？
SELECT matiere_premiere.`code`,
matiere_premiere.`designation`,
matiere_premiere.`unite`,
matiere_premiere.`frns` ,
IF(ISNULL(REQ.qte), '0.00', REQ.qte) AS qte
FROM matiere_premiere
LEFT JOIN (SELECT qte,matiere_premiere_code
FROM stock_mp JOIN matiere_premiere
ON matiere_premiere.`code` = matiere_premiere_code
WHERE DATE <= CURRENT_DATE()
ORDER BY DATE DESC
) AS REQ ON REQ.matiere_premiere_code = matiere_premiere.`code`
GROUP BY matiere_premiere.`code`
ORDER BY matiere_premiere.`code`回答 1
Stack Overflow用户
发布于 2015-04-22 21:31:46
这应该是可行的，但它还没有经过测试。您可能想要研究一下LinqPad
var now = DateTime.Now;
from m in matiere_preiere
join req in
(from s in stock_mp
join m2 in matire_preimere on s.code equals m2.matire_preiere_code
where s.Date <= now
select new {qte, matirere_premiere_code})
on req.matirere_premiere_code equals m.code into reql
from req in reql.DefaultIfEmpty()
order by m.code
select new {m.code, m.designation, m.unite,m.frns, qte=req.qte ?? 0.00}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/29733354
复制相关文章
相似问题
腾讯云开发者
