由网友(貝多芬の悲傷゜)分享简介：我要寻找一种方式在LINQ to匹配跟随SQL查询。SELECT MAX（UID）的UID，SERIAL_NUMBER从表GROUP BY SERIAL_NUMBER真的找对这一一些帮助。上述查询得到的每一个序列号，因为分组方式语法的最大UID。解决方案 使用（的DataContext DC =新的DataCont...

我要寻找一种方式在LINQ to匹配跟随SQL查询。

  SELECT MAX（UID）的UID，SERIAL_NUMBER从表GROUP BY SERIAL_NUMBER
 

真的找对这一一些帮助。上述查询得到的每一个序列号，因为分组方式语法的最大UID。

解决方案

 使用（的DataContext DC =新的DataContext（））
        {
            变种Q =从dc.TableTests牛逼
                    鲁汶由t.SerialNumber
                        为G
                        选择新
                        {
                            的SerialNumber = g.Key，
                            UID =（从T2在g选择t2.uid）的.max（）
                        };
        }
 

I am looking for a way in LINQ to match the follow SQL Query.

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

Really looking for some help on this one. The above query gets the max uid of each Serial Number because of the Group By Syntax.

解决方案

        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()
                        };
        }