LINQPad_v4.31 绿色破解版

linq 调试工具，本人测试通过。 from p in Products let spanishOrders = p.OrderDetails.Where (o => o.Order.ShipCountry == "Spain") where spanishOrders.Any() orderby p.ProductName select new { p.ProductName, p.Category.CategoryName, Orders = spanishOrders.Count(), TotalValue = spanishOrders.Sum (o => o.UnitPrice * o.Quantity) }