How do I get a lambda query that is like this tsql query?
===

The T-SQL query:

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

Attempted lambda query:

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

The lambda query doesn't work.