- 3,715,652 Users
- 2,242,819 Discussions
- 7,845,478 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 466 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 416 SQLcl
- 42 SQL Developer Data Modeler
- 184.8K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 8 DevOps
- 3K QA/Testing
- 247 Java
- 5 Java Learning Subscription
- 10 Database Connectivity
- 66 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 10 Español
- 1.9K Japanese
- 2 Portuguese
use datetime.today() in where,got wrong sql
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
Answers
-
Which 11g DB version are you using? 11.1 or 11.2? Are you setting the UseOracleSQLCompatibility("11") extension method?
-
I using 11.2.And i also set the UseOracleSQLCompatibility("11") .
-
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
-
Maybe you can create table by the sql.
create table PARENT( id VARCHAR2(10), a VARCHAR2(10), b VARCHAR2(10), c DATE)