我的SQL查询如下所示:SQL查询返回与每个colorwaysid相关联的收入
select p.colorwaysid,sum(oivs.actItemvalue+oivs.custom) as revenue
from Product p inner join eshakti_corp..orderitemvaluesplit oivs on p.productid = oivs.productid
inner join eshakti_corp..orders o on oivs.orderid = o.orderid
where colorwaysid is not null and o.crdate >= '4/1/2022' and o.crdate <= '4/30/2022'
group by p.colorwaysid order by revenue desc
到目前为止,我已经在LINQ C#中完成了这一工作
from product in eshaktiDb.Products
join oivs in corpDb.OrderitemvalueSplits on product.ProductId equals oivs.Productid
join order in corpDb.Orders on oivs.Orderid equals order.OrderID
where product.ColorWaysId != null && order.CrDate >= fromDate && order.CrDate <= toDate
请帮助我创建完整的Linq查询。谢谢!
1条答案
按热度按时间kqqjbcuj1#
group by
部分很明显:请注意,如果正确配置了导航属性,则可以省略联接。