如何将此GROUP BY/MIN SQL查询转换为LINQ? [英] How do I translate this GROUP BY / MIN SQL query into LINQ?

问题描述

我计划在子查询中使用它，但无法找出将以下查询转换为LINQ的正确语法:

I plan on using this in a subquery but can't figure out the correct syntax to translate the following query into LINQ:

select ChapterID, min(MeetingDate)
from ChapterMeeting
group by ChapterID

推荐答案

var query = myDataContext.ChapterMeeting
  .GroupBy(cm => cm.ChapterID)
  .Select(g => new {
      g.Key,
      MinMeetingDate = g.Min(cm => cm.MeetingDate)
  });

这篇关于如何将此GROUP BY/MIN SQL查询转换为LINQ?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！