Linq: Difference between 2 DateTimes in TimeSpan

Question

I'm trying to do this:

Tickets.Where(t => (t.Date - myTicket.Date) < TimeSpan.FromSeconds(120));

I'm getting the "DbArithmeticExpression arguments must have a numeric common type" error. How can I do this, considering that I need the difference in a TimeSpan?

Thanks in advance.

Answer 1

You would want to use SqlFunctions.DateDiff

Tickets.Where(t => 
      SqlFunctions.DateDiff("second", t.Date, myTicket.Date) < 120));

Answer 2

You can also use this;

var result = db.Tickets.Where(t => 
       SqlMethods.DateDiffSecond(myTicket.Date ,  t.Date) < 120);

Answer 3

Arithmetic with DateTime is not supported in Entity Framework. You have to use one of the SqlFunctions. So, for your statement, something like:

Tickets.Where(t => 
      SqlFunctions.DateDiff("second", t.Date, myTicket.Date) < 120));