TSql 到 Linq 翻译

发布于 2024-12-01 08:18:38 字数 405 浏览 1 评论 0原文

我如何将其转换为 Linq to SQL

我想要获取所有消息响应 (mr),但对于 mr 中的每个数字,我只想要在发送第一条消息 (m) 后收到的消息

 select mr.*
     from 
      (select distinct PhoneNumber, MIN(SentDate) as MinSentDate
        from Messages 
        groupby PhoneNumber)m, 
        join        
        MessageResponses mr on m.PhoneNumber = mr.PhoneNumber

        where mr.ReceivedDate > m.MinSentDate

tks

how can I translate this to Linq to SQL

I want to get all message responses (mr) but for each number in mr I only want messages that were received after the 1st message (m) was sent

 select mr.*
     from 
      (select distinct PhoneNumber, MIN(SentDate) as MinSentDate
        from Messages 
        groupby PhoneNumber)m, 
        join        
        MessageResponses mr on m.PhoneNumber = mr.PhoneNumber

        where mr.ReceivedDate > m.MinSentDate

tks

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

扫码二维码加入Web技术交流群

发布评论

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

评论(1

酷遇一生 2024-12-08 08:18:38

它看起来像这样

var query = from m in (from me in context.Messages
                       group me by me.PhoneNumber into mgr
                       select new
                       {
                         PhoneNumber = mgr.Key,
                         MinSentDate = mgr.Select(x => x.SentDate).Min()
                       }).Distinct()
            join mr in context.MessageResponses
            on m.PhoneNumber equals mr.PhoneNumber
            where mr.ReceivedDate > m.MinSentDate
            select mr; 

It would look something like this

var query = from m in (from me in context.Messages
                       group me by me.PhoneNumber into mgr
                       select new
                       {
                         PhoneNumber = mgr.Key,
                         MinSentDate = mgr.Select(x => x.SentDate).Min()
                       }).Distinct()
            join mr in context.MessageResponses
            on m.PhoneNumber equals mr.PhoneNumber
            where mr.ReceivedDate > m.MinSentDate
            select mr; 
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文