Mohammed Rafi Khan

Mohammed Rafi Khan

  • NA
  • 349
  • 33.3k

please convert the below sql code to linq

Aug 26 2016 8:11 AM
select A.col1,A.col2,A.col3,A.col4,A.col5,A.col6,A.col7,C.col8,case when B.col1 is null then 'False' else 'True' end From
(
select * from xyz
)A
left outer join
(
select col1=max(col1),col2 from abc
group by col2
)B
on B.col1=A.col1
inner join def C on C.col1=A.col1
order by a.col2

Answers (1)