- 3,723,860 Users
- 2,244,635 Discussions
- 7,850,737 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.1K Databases
- 615 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 497 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 422 SQLcl
- 62 SQL Developer Data Modeler
- 185.1K SQL & PL/SQL
- 21.1K SQL Developer
- 2.4K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.6K Development Tools
- 14 DevOps
- 3K QA/Testing
- 337 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 72 Java Community Process
- 2 Java 25
- 12 Java APIs
- 141.2K Java Development Tools
- 8 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
- 16 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 147 LiveLabs
- 34 Workshops
- 10 Software
- 4 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
Difference between Dates / Entity Framework Core 3.1
Hello,
I have an exception when I try to get the difference between two dates (in Days) with the new Oracle.EntityFrameworkCore 3.19.0-beta1 NuGet package :
var row = (
from r in dbContext.Entitites
select new { (DateTime.Now - r.DateTimeColumn).Days }
).FirstOrDefault();
System.InvalidCastException: 'Specified cast is not valid.'
at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDecimal(Int32 i)
at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
at System.Data.Common.DbDataReader.GetFieldValue[T](Int32 ordinal)
Best Answer
-
Yes, this bug will be fixed in production. The fix just missed our beta 2 freeze date.
Answers
-
Hi,
didn't see your post before mine but you can look at it for a temporary solution: Using DateTime.Today breaks with Entity Framework Core 3.1
Looks like if you pass a variable instead of DateTime.Now, it works.
-
I've filed Bug 31423881 to track this issue. The Oracle team will review the bug.
-
-
Unfortunately, I cannot publish with beta bugs. Nonetheless, I'm happy to update the status.
My team tried to reproduce the issue with the same query, but do not see the error. We created a table with a DateTime column, inserted a value, then ran the query. Are there other necessary conditions that need to be present for the error to occur? For example, does it occur with certain results only or a different time-based column type?
-
Here is a sample project (with an EF migration to create the table) that reproduces the problem : https://github.com/kakone/OracleBug31423881
I use an Oracle Server version 12.1.0.1.0 on Windows. -
Thanks for the test case! I can reproduce the problem. I will upload your test case to the bug.
-
The bug is not fixed with the beta 2 ;(
Is there any hope that it will be fixed in the final release ? -
Yes, this bug will be fixed in production. The fix just missed our beta 2 freeze date.