use datetime.today() in where,got wrong sql

3975927

I use .NetCore 2.2 ,Oracle.EntityframeWork(v2.19.50)  oracle (11g).

When i use  the condition  "x=>x.C>DateTime.Today()&&x.C<DateTime.Today().AddDays(1)".

I got the sql wrong.

Here is the test:

Model:

         public string Id { get; set; }         public string A { get; set; }         public string B { get; set; }         public DateTime? C { get; set; }    }public class Parent {

Linq:

await _dbcontext.Parents.Where(o => o.C >= DateTime.Today && o.C < DateTime.Today.AddDays(1)).Select(o => o.Id).ToListAsync();

General SQL:

 SELECT "o"."C", "o"."ID"    FROM "PARENT" "o"    WHERE ("o"."C" >= "TRUNC"(SYSDATE))

you can also find the repo in https://github.com/362486122/ef-oracle-test/tree/master

Alex Keh-Oracle

Which 11g DB version are you using? 11.1 or 11.2? Are you setting the UseOracleSQLCompatibility("11") extension method?

3975927

I using 11.2.And i also set the UseOracleSQLCompatibility("11") .

Alex Keh-Oracle

I tried running your EF Core test case on GitHub. When I started the migration, I got the following error:

Unable to create an object of type 'MyDbContext'. For the different patterns supported at design time, see https://go.microsoft.com/fwlink/?linkid=851728

3975927

Maybe you can create table by the sql.

create table PARENT(  id VARCHAR2(10),  a  VARCHAR2(10),  b  VARCHAR2(10),  c  DATE)