Ritu

Ritu

  • 1.4k
  • 347
  • 42.6k

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)