.net - 如何在 LINQ 查询中使用 GROUP BY 获取 MAX 行？

Question

我正在寻找一种在 LINQ 中匹配以下 SQL 查询的方法。

Select max(uid) as uid, Serial_Number from Table Group BY Serial_Number

确实在寻找有关此问题的帮助。由于 Group By 语法，上述查询获取每个序列号的最大 uid。

Answer 1

        using (DataContext dc = new DataContext())
        {
            var q = from t in dc.TableTests
                    group t by t.SerialNumber
                        into g
                        select new
                        {
                            SerialNumber = g.Key,
                            uid = (from t2 in g select t2.uid).Max()
                        };
        }