如何将此 GROUP BY / MIN SQL 查询转换为 LINQ？

发布于 2024-07-15 08:59:43 字数 144 浏览 9 评论 0原文

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

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

原文

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

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

孤星 2024-07-22 08:59:43

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

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

回复收藏 0 原文

毁虫ゝ 2024-07-22 08:59:43

好吧，艾米比我先一步，但如果你想用“理解”语法来查看它：

var q = (
    from cm in context.ChapterMeeting
    group cm by cm.ChapterID into cmg
    select new {
        ChapterID = cmg.Key,
        FirstMeetingDate = cmg.Min(cm => cm.MeetingDate)});

Well, Amy beat me to it, but in case you wanted to see it with the "comprehension" syntax:

var q = (
    from cm in context.ChapterMeeting
    group cm by cm.ChapterID into cmg
    select new {
        ChapterID = cmg.Key,
        FirstMeetingDate = cmg.Min(cm => cm.MeetingDate)});

回复收藏 0 原文

~没有更多了~