Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET Entity Framework Core Beta 3 Datetime field

Jonas MachadoJun 3 2019 — edited Jul 16 2019

I'm using ODP.NET Entity Framework Core Beta 3 with migrations and I'm getting an error when adding a new field of DateTime type. When It is the creation of the table it works fine but when its an update, the command  'dotnet ef database update' throws an error wich says "the right parenthesis is missing".

The SQL Generated in update is:

ALTER TABLE <TABLE> add <FIELD_NAME> Timestamp(7) DEFAULT TO_DATE(''0001-01-01 00:00:00'', ''YYYY-MM-DD HH24:MI:SS'') NOT NULL

It is probably a bug of this version. Is it possible to do anything to fix it manually/temporarelly?
Is there a way to require a fix for a future version?

Thanks.

This post has been answered by Alex Keh-Oracle on Jun 4 2019
Jump to Answer

Comments

Post Details

Added on Jun 3 2019
8 comments
1,314 views