on delete cascade is not created

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Dunkelmann
Posts: 13
Joined: Fri 05 Apr 2013 08:43

on delete cascade is not created

Post by Dunkelmann » Mon 13 Jun 2016 07:47

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: on delete cascade is not created

Post by Shalex » Mon 13 Jun 2016 14:55

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.

Post Reply