Linq nhibernate 分组和加入

发布于 2024-10-26 06:22:28 字数 752 浏览 1 评论 0原文

考虑一个简单的订单示例（应该获取每个产品的标题和订购数量）：（注意 - 按标题分组不是一个好的答案）

var orderQuery = 
    session.Query<OrderLine>()
           .Where(ol => ol.Quantity > 0)
           .GroupBy(ol => ol.Product.Id)
           .Select(x => new 
                        { 
                            productId = x.Key, 
                            quantity = x.Sum(i => i.Quantity) 
                        });

var query = 
    session.Query<Product>()
           .Join(orderQuery, 
                    x => x.Id, 
                    x => x.productId, 
                    (x, p) => new { x.FeedItem.Title, p.quantity });

但是，这会引发

无法解析属性：Key of：OrderLine

有什么想法吗？

原文

Consider a simple order example (should get the title and quantity ordered for each product):
(note - grouping by Title is not a good answer)

var orderQuery = 
    session.Query<OrderLine>()
           .Where(ol => ol.Quantity > 0)
           .GroupBy(ol => ol.Product.Id)
           .Select(x => new 
                        { 
                            productId = x.Key, 
                            quantity = x.Sum(i => i.Quantity) 
                        });

var query = 
    session.Query<Product>()
           .Join(orderQuery, 
                    x => x.Id, 
                    x => x.productId, 
                    (x, p) => new { x.FeedItem.Title, p.quantity });

However, this throws a