TSql 到 Linq 翻译
我如何将其转换为 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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
它看起来像这样
It would look something like this