I been trying to convert this T-SQL code to EF, but I am not having much luck. Any help would be great.
SELECT
Prev2.ContinuedMeetingId AS PreviousValue
FROM
[Meeting] This
OUTER APPLY
(SELECT
prev.ContinuedMeetingId
FROM
[Meeting] prev
WHERE
Prev.ContinuedMeetingId < This.MeetingId) Prev2
WHERE
This.MeetingId = 2710
EF / Linq:
var query1 = (from m in db.Meetings
where m.MeetingId == MeetingId
select new
{
m,
SubName = db.Meetings
.Where(s => m.MeetingId == s.MeetingId)
.Select(s => s.ContinuedMeetingId)
}).ToList();