Foreign key violations issue

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
chiccodoro
Posts: 7
Joined: Thu 15 Sep 2011 09:35

Foreign key violations issue

Post by chiccodoro » Thu 15 Sep 2011 09:45

Hi all,

We are evaluating dotConnect for Oracle and have transitioned our EF4.1 Code First project from SQL Server CE to Oracle. The (almost) only issue we are facing since then:

We have a piece of code that deletes an entity which has child entities and "grand child" entities. All of them are supposed to be deleted (cascade). We only delete the main entity:

context.People.Remove(personToRemove);
context.SaveChanges()

It used to work with SQLServer CE, but with dotConnect for Oracle it now fails due to Oracle Foreign Key violations.

I know we could solve this by adding "ON CASCADE DELETE" to the DDL of the FK constraints, if we did it by hand.. But how can we make dotConnect add these cascades?

Thanks

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

Post by Shalex » Fri 16 Sep 2011 16:03

Thank you for your report. We will investigate the issue and notify you about the results as soon as possible.

Post Reply