DATEDIFF (in months) in linq

advertisements
select col1,col2,col3 from table1
where(DATEDIFF(mm, tblAccount.[State Change Date], GETDATE()) <= 4

I want to convert this sql query to LINQ. but I dont know any DateDiff alternative in LINQ. can you please suggest me?


You're looking for SqlMethods.DateDiffMonth.

EDIT: In EF4, use SqlFunctions.DateDiff.