CODEWITHSUNDEEP
asp.net-mvcentity-framework
reidLinden
reidLinden

Reputation: 4160

EF SaveChanges Error

The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_tblStmtTask_StmtBatchID". The conflict occurred in database "CRM", table "dbo.tblStmtBatch", column 'ID'.

The statement has been terminated

I"m getting this error while saving a modification to 'tblStmtTask' .. I understand that I have a foreign key to the 'tblStmtBatch', but I haven't a clue why changing an unrelated column in the task should have any impact on the batch.

How do I decipher what the root cause of this error actually is ?

Upvotes: 2

Views: 992

Answers (1)

Mekswoll
Mekswoll

Reputation: 1433

Place a breakpoint on the update statement. The FK property will be empty. In order to find the step where it is set to empty your best bet is to breakpoint the point of creation of the entity and step through it so can pinpoint the place where the FK gets set to empty.

If the FK property is empty at creation there has been a problem with mapping. If the entity is being created with the DefaultModelBinder, make sure you have provided the FK property in your form as well, e.g. using the @Html.HiddenFor HTML helper.

Upvotes: 2

Related Questions