DevOps, CI/CD and Automation

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!

Oracle.EntityFrameworkCore Guid column not null script incorrect

51392a16-5ec9-476a-a7e6-d4ba00f1eaf5Sep 16 2019 — edited Sep 16 2019

Hello,

I am using Oracle.EntityFrameworkCore version 2.19.30 with .net Core 2.2 and OracleSQLcompatibility set to 11.

I added a column of type Guid in C# and the script generated was:

ALTER TABLE "CUSTOMER" ADD "FILE_ID" RAW(16) DEFAULT ''00000000000000000000000000000000'' NOT NULL

When I execute this command manually, i have an Oracle Error: ORA-01735: invalid ALTER TABLE option.

I need to remove the double quote as follow to make it work:

ALTER TABLE "DESTINATAIRE" ADD "FILE_ID" RAW(16) DEFAULT '00000000000000000000000000000000' NOT NULL

Could you please fix this issue in your next version ?

Thanks and regards,

Thomas

Added on Sep 16 2019

#oracle-providers-for-asp-net, #windows-and-net

0 comments

728 views