我正在尋找一種在LINQ中匹配以下SQL查詢的方法。Select max(uid) as uid, Serial_Number from Table Group BY Serial_Number真的在這方面尋求一些幫助。上面的查詢由于Group By語法而獲得每個序列號的最大uid 。
3 回答
神不在的星期二
TA貢獻1963條經(jīng)驗 獲得超6個贊
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()
};
}
交互式愛情
TA貢獻1712條經(jīng)驗 獲得超3個贊
var q = from s in db.Serials
group s by s.Serial_Number into g
select new {Serial_Number = g.Key, MaxUid = g.Max(s => s.uid) }
互換的青春
TA貢獻1797條經(jīng)驗 獲得超6個贊
以方法鏈形式：
db.Serials.GroupBy(i => i.Serial_Number).Select(g => new
{
Serial_Number = g.Key,
uid = g.Max(row => row.uid)
});
- 3 回答
- 0 關注
- 887 瀏覽
添加回答
舉報
0/150
提交
取消