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.