how to solve:An unhandled exception occurred while processing the request. SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Doctors_Users_UserId".

Question

how to solve:An unhandled exception occurred while processing the request. SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Doctors_Users_UserId".

karen matungwa 0

An unhandled exception occurred while processing the request.

SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Doctors_Users_UserId". The conflict occurred in database "Diabetes2AppDb", table "dbo.Users", column 'Id'.

Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)

DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(int startCommandIndex, RelationalDataReader reader, CancellationToken cancellationToken)

P a u l 10,761 Reputation points

2024-05-26T19:36:04.12+00:00

Can you show the code generates this error? It looks like you're inserting a Doctor that contains a UserId that doesn't relate to any row in the User table. Does the user exist?
Anonymous

2024-05-27T09:12:14.18+00:00
Hi,@karen matungwa. Welcome to Microsoft Q&A.

The preliminary judgment is that the foreign key inserted into the data does not comply with the constraints of the foreign key defined in the database. You can check the data you want to pass in in more detail, whether the foreign key type is correct, and whether the foreign key value meets the constraints. If you use the SQL command to pass in the data, you should also check whether the SQL statement has errors.

If the problem still occurs, please give a sample code that simply highlights the problem

Your answer

P a u l 10,761 Reputation points

2024-05-26T19:36:04.12+00:00

Can you show the code generates this error? It looks like you're inserting a Doctor that contains a UserId that doesn't relate to any row in the User table. Does the user exist?
Anonymous

2024-05-27T09:12:14.18+00:00

Hi,@karen matungwa. Welcome to Microsoft Q&A.

The preliminary judgment is that the foreign key inserted into the data does not comply with the constraints of the foreign key defined in the database. You can check the data you want to pass in in more detail, whether the foreign key type is correct, and whether the foreign key value meets the constraints. If you use the SQL command to pass in the data, you should also check whether the SQL statement has errors.

If the problem still occurs, please give a sample code that simply highlights the problem

Share via

how to solve:An unhandled exception occurred while processing the request. SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Doctors_Users_UserId".

Your answer