c# - 如何获得类似于此 tsql 查询的 lambda 查询？

Question

有一个 T-SQL 查询:

select [ProductNumber] ,max([ProductRevNumber])
from Products  
group by [ProductNumber]

尝试的 LINQ 查询:

ProductsDBContext.Products.GroupBy(x => x.ProductRevNumber)
                          .Select(group => ProductNumber, 
                                           ProductRevNumber = group.Max(x => x.ProductRevNumber));

lambda 查询不起作用。

Answer 1

我认为这就是您所追求的:

var latestProducts = ProductsDBContext.Products
    .GroupBy(p => p.ProductNumber).Select(g => new 
    {
        ProductNumber = g.Key,
        MaxProductRevNumber = g.Max(p => p.ProductRevNumber))
    });