Not a real answer but... there is a tool called
Linqer[
^] which can convert from SQL to Linq - you can get a trial which will get you out of your immediate problem.
I have found Linq to be very frustrating at times, some SQL functions such as DateDiff are just not supported or extremely problematic to implement. When I run into these issues in MVC is revert to straight SQL - refer
Entity Framework Raw SQL Queries[
^]
Kind Regards