LINQ self referencing query
- by Chris
I have the following SQL query:
select
p1.[id],
p1.[useraccountid],
p1.[subject],
p1.[message],
p1.[views],
p1.[parentid],
case
when p2.[created] is null then p1.[created]
else p2.[created]
end as LastUpdate
from forumposts p1
left join
(
select
parentid,…