TSql 到 Linq 翻译

Question

我如何将其转换为 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

Answer 1

它看起来像这样

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;