Update Statement Error - SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint When I Try To Edit

Question

I want users to be able to edit what they already created and save the changes to the db. When I test editing out, I get this error:

SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_REPTILES_AspNetUsers_ApplicationUserId". The conflict occurred in database "PetAdoptDB", table "dbo.AspNetUsers", column "Id"

I tried modifying the foreign key to cascade instead of no action which I found here Link, but, I still get the error.

While debugging I noticed that the ApplicationUser is null and ApplicationUserId equals 0 when running

_context.Update(reptile);

Not sure if that's the problem or not and if so, how to fix it.

You need to retrieve applicationuser first, set it in your entity reptile then call the update on your dbcontext. — Willy David Jr, Aug 16 '20 at 10:43
Please don't post images of text, instead post the text as its much easier to read. — Dale K, Aug 17 '20 at 00:15
@WillyDavidJr Trying your way, just having a hard time getting the applicationuser that created the reptile. — Enoch Johnson, Aug 17 '20 at 07:43

score 0 · Accepted Answer · answered Aug 18 '20 at 08:37

0

I got it working by using <input type="hidden" asp-for="ApplicationUserId" /> within the form on the edit page.

answered Aug 18 '20 at 08:37

Enoch Johnson

37
7

Update Statement Error - SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint When I Try To Edit

1 Answers1