.net - 如何将 SQL 查询转换为 LINQ？

Question

我是 LINQ 的新手。谁能帮我将以下 SQL 查询转换为 LINQ？

SELECT 
   Date,ShiftName,Max(Score) AS Score, 1 AS IsPreferred  
FROM 
   Temp_Nurse_Fill_RequestNumbers 
group by 
   ShiftName,date

Answer 1

from t in Temp_Nurse_Fill_RequestNumbers 
group by t.ShiftName, t.date
into g 
select new 
{
   Date = g.date,
   Score = (from tt in g select tt.Score).max
   IsPreferred = 1
};