使用GroupBy和Average将SQL转换为lambda LINQ [英] Translate SQL to lambda LINQ with GroupBy and Average

问题描述

我花了几个小时试图将简单SQL转换为lambda LINQ

I spend a few hours trying to translate simple SQL to lambda LINQ

SELECT ID, AVG(Score) FROM myTable
GROUP BY ID

有什么想法？

Any idea?

推荐答案

from t in myTable
group t by new {
  t.ID
} into g
select new {
  Average = g.Average(p => p.Score),
  g.Key.ID
}

或 Lambda

myTable.GroupBy(t => new  {ID = t.ID})
   .Select (g => new {
            Average = g.Average (p => p.Score), 
            ID = g.Key.ID 
         })

这篇关于使用GroupBy和Average将SQL转换为lambda LINQ的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！