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

c#, entity-framework, group-by, linq, t-sql

Solution

I think this is what you are after:

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

Problem

Having a T-SQL query: ``` select [ProductNumber] ,max([ProductRevNumber]) from Products group by [ProductNumber] ``` Attempted LINQ query: ``` ProductsDBContext.Products.GroupBy(x => x.ProductRevNumber) .Select(group => ProductNumber, ProductRevNumber = group.Max(x => x.ProductRevNumber)); ``` The lambda query doesn't work.

Original source