Entity Framework Datetime Conversion

162 Views Asked by At

I'm trying to get some records from my table (DB: Oracle) by using Entity Framework lambda expression and I have only one date property to filter records (DiscussionDate > DateTime.Now).

However, EF is producing SQL query WHERE condition like this;

SELECT ...
FROM ...
WHERE ("Extent1"."DiscussionDate" > (LOCALTIMESTAMP)

Is it possible to produce the script with (SYSDATE) instead of (LOCALTIMESTAMP) in Entity Framework auto generated queries?

0

There are 0 best solutions below