I been trying to convert this TSQL into ef but I am not having much luck. Any help would be great.
<code>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
</code>
<code>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
</code>
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
<code>var ContinuedMeetingIds = (from m in db.Meetings
where m.MeetingId == MeetingId
let ContinuedMeetingId = m.ContinuedMeetingId.Value.Select(x => x.).OrderByDescending(c => c).FirstOrDefault
</code>
<code>var ContinuedMeetingIds = (from m in db.Meetings
where m.MeetingId == MeetingId
let ContinuedMeetingId = m.ContinuedMeetingId.Value.Select(x => x.).OrderByDescending(c => c).FirstOrDefault
</code>
var ContinuedMeetingIds = (from m in db.Meetings
where m.MeetingId == MeetingId
let ContinuedMeetingId = m.ContinuedMeetingId.Value.Select(x => x.).OrderByDescending(c => c).FirstOrDefault