Hello,
I am evaluationg oracle .net Provider and sqlite .net provider (latest versions)
(SQLite Professional registered, Oracle Evaluation License)
I have a simple EF6 Model with one master and one detail class.
If I use Oracle Provider, Entity Developer creates
CREATE TABLE PLAYGROUND.DETAILS (
ID NUMBER(10) NOT NULL,
SUBREMARK CLOB NULL,
MASTERID NUMBER(10) NOT NULL,
CONSTRAINT PK_DETAILS PRIMARY KEY (ID),
CONSTRAINT FK_DETAILS_MASTERS_0 FOREIGN KEY (MASTERID) REFERENCES PLAYGROUND.MASTERS (ID)
);
If i use SQLITE provider, Entity Developer creates
CREATE TABLE PLAYGROUND.DETAILS (
ID INTEGER PRIMARY KEY AUTOINCREMENT,
SUBREMARK CLOB,
MASTERID INT64 NOT NULL,
CONSTRAINT FK_DET_MAST FOREIGN KEY (MASTERID) REFERENCES MASTERS (ID) ON DELETE CASCADE
);
So when using Entity Developer with Oracle Provider, the "on delete cascade" is missing in the database script.
I also tried an EF Core Model, the 'on delete cascade' or 'on delete set null' statements are not being created.
Can you help me solve this Issue?
thanks
Marcus
on delete cascade is not created
Re: on delete cascade is not created
The bug with applying the ON DELETE CASCADE option by Create Model Wizard and Update Model From Database Wizard is fixed (Oracle). We will notify you when the new public build of dotConnect for Oracle is available for download.