Compare DateTime in Sqlite with Entity and Linq

Question

I'm trying to run the following:

backupEvents = backupEvents.Where(e => e.Timestamp >= DateTime.Now - new TimeSpan(0, 1, 0, 0));

But this gives me an error saying

"DbArithmeticExpression arguments must have a numeric common type".

Searching StackOverflow, I find that Arithmetic with DateTime is not supported in Entity Framework.

So I tried:

backupEvents = backupEvents.Where(o => DbFunctions.DiffHours(o.Timestamp, DateTime.Now) <= 1);

But I also can't use the DbFunctions offered as a solution, because I'm using SQLite, and it doesn't have them, and I get an error saying: "no such function: DiffHours"

So - is there a way to compare dates in SQLite, using entity?

Maverick Meerkat · Accepted Answer · 2017-09-20 14:52:26Z

1

Found a way - this works:

DateTime offsetHour = DateTime.Now.Add(new TimeSpan(-1, 0, 0));
backupEvents = backupEvents.Where(e => e.Timestamp >= offsetHour);

answered Sep 20, 2017 at 14:52

Maverick Meerkat

6,4723 gold badges54 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare DateTime in Sqlite with Entity and Linq

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related