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()
};
}
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) }
Я проверил ответ DamienG в LinqPad. Вместо
g.Group.Max(s => s.uid)
должно быть
g.Max(s => s.uid)
Спасибо!