有没有更简单的方法来执行以下linq EF查询? [英] Is there an easier way to do the following linq EF query ?
问题描述
是否有更简单的方法来执行以下linq查询?
var list = query.ToList();
list。 ForEach(r => roTotal 数量 = r.Total 数量);
IList < 订单 > result = list.Select(r => ro).ToList();
嗨Bigyes
我不确定你在尝试什么。我期望订单中所有订单行的Maxquantity为order.TotalQuantity-value。我想你试着设置order.TotalQuantity-value作为所有orderline-quantity的总和,对吗?
这个的解决方案是:
1
列表与LT;排序>订单= ctx.Order.ToList();
2
orders.ForEach(O => o.TotalQuantity = o.OrderLines.Sum(OD => od.Quantity));
Is there an easier way to do the following linq query ? var query = from o in ctx.Order select new {o , TotalQuantity = o.OrderLines.Max(l => l.Quantity)};
var list = query.ToList();
list.ForEach(r=>r.o.TotalQuantity = r.TotalQuantity);
IList<Order> result = list.Select(r => r.o).ToList();
解决方案Hi Bigyes
I'm not sure what you're trying. I'm expecting the Maxquantity of all orderlines in an order as order.TotalQuantity-value. I think you try to set the order.TotalQuantity-value as a sum of all orderline-quantities, right?
The solution for this is:
1 List<Order> orders = ctx.Order.ToList(); 2 orders.ForEach(o => o.TotalQuantity = o.OrderLines.Sum(od => od.Quantity));
这篇关于有没有更简单的方法来执行以下linq EF查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文