How to resolve conflict during deleting records from database using entity framework?

Question

The DELETE statement conflicted with the REFERENCE constraint > "FK_dbo.VendorDocuments_dbo.VendorModels_VendorId". The conflict occurred in database > "aegisv", table "dbo.VendorDocuments", column 'VendorId'. The statement has been terminated.

Means I have one table of VendorModel which has list of invoicedocument(it is a model with foreign key vendorId of table vendor model). when I am trying to delete Vendor model from database I am getting above exception.

I have tried various things but I haven't resolve same yet.

Have added following code but doesn't worked.

      modelBuilder.Entity<VendorDocument>()
            .HasRequired(x => x.VendorModel)
            .WithMany(u => u.VendorDocumemts)
            .WillCascadeOnDelete();

Please any one can help me.. Thank you.

Can you post your Delete action? It could be that when you're loading your model for Delete, you're not including the related entities. — Evonet, Oct 08 '13 at 12:23

score 0 · Answer 1 · answered Oct 08 '13 at 10:48

0

Just change in little bit code here,try it :-

 modelBuilder.Entity<VendorDocument>()
            .HasOptional(j => j.VendorModel)
            .WithMany(u => u.VendorDocumemts)
            .WillCascadeOnDelete(true);

answered Oct 08 '13 at 10:48

kaushik0033

679
6
12

Dude have tried same and now I am getting following exception during login..Multiplicity conflicts with the referential constraint in Role 'VendorDocument_VendorModel_Target' in – Vikas Oct 08 '13 at 11:34
Please see link http://stackoverflow.com/questions/8007129/codefirst-ef4-1-mvc-against-legacy-database-multiplicity-conflicts – kaushik0033 Oct 08 '13 at 12:37

score 0 · Answer 2 · edited May 23 '17 at 11:50

You have to enable cascade delete rule on database also. EF does not take responsibility for cascading the delete in the database.

The EF is responsible for the correctness of the ObjectContext after SaveChanges(). So the EF attempts to synchronize the ObjectContext, with the expected database state after the expected cascade in the database.

So If you have created Cascade Delete rule in your model, you must have to configure Cascade delete rule in your database. Tip 33

To enable Cascade Delete rule in database -Enable CascadeDelete

How to resolve conflict during deleting records from database using entity framework?

2 Answers2