Calculate mins in Linq

Question

I am trying to do this to calculate the LastDate is more then 15 mins in LINQ:

And DateTimeOffset.Now.Subtract(tbl.LastDate).Minutes >= 15

I got this error:

Method 'System.TimeSpan Subtract(System.DateTimeOffset)' has no supported translation to SQL.

[This question](http://stackoverflow.com/questions/200617/how-do-i-use-sqls-getdate-and-dateadd-in-a-linq-to-sql-expression) about using `GETDATE` and `DATEADD` might help you. — Bob Kaufman, Dec 30 '15 at 03:58

Anik Saha · Accepted Answer · 2015-12-30T05:22:27.797

1

You can use the EntityFunctions class to perform operations on dates, among other things.

And (tbl.LastDate >= EntityFunctions.AddMinutes(DateTime.Now, -15))

if you are not using entityfunction you can do that

DateTime oldestDate = DateTime.Now.AddMinutes(-15);

... then modified the where portion of the LINQ query

And (tbl.LastDate >= oldestDate )

edited Dec 30 '15 at 05:22

answered Dec 30 '15 at 04:35

Anik Saha

EntityFunctions is not declare, I am using .net 4.0 – Alvin Dec 30 '15 at 05:05
I tried this => And tbl.LastDate >= DateTimeOffset.Now.AddMinutes(-15), I think it should be the same like your answer? – Alvin Dec 30 '15 at 05:23
I dont calculate it in linq. After calcuating it do you get right answer or not? Calcutating linq may give you exception. – Anik Saha Dec 30 '15 at 05:31

1 Answers1