Ritu

Ritu

  • 1.3k
  • 344
  • 37.9k

convert sql query to c# lambda query

Aug 12 2023 7:02 AM

Hi 

I want to convert sql query to c# lambda query

selelct * from ABC where  joiningdate between (Select top 1  DateAdd(d, -90,joiningdate) from ABC order by joiningdate desc) and (Select top 1 joiningdate from ABC order by joiningdate desc)

I need to convert WHERE clause in c# lambda query

Thanks.


Answers (4)