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?