The DELETE st conflicted with the REF constraint in mvc

sonal malhotra

hello mvc users,

i cant understand that error

The DELETE statement conflicted with the REFERENCE constraint "FK_dbo.Appointments_dbo.Patients_PatientId". The conflict occurred in database "ClinicDB", table "dbo.Appointments", column 'PatientId'.

The statement has been terminated. And

And in patient configuration class

there is code below

HasMany(p => p.Appointments)

.WithRequired(a => a.Patient)

.WillCascadeOnDelete(true);

what else ? anything

how to fix this prob?

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sundaram Subramanian6y ago
How many rows are there in Patient Table ?.
sonal malhotra6y ago
reply ..what to do
sonal malhotra6y ago
hello what can i do now ? i cant understand
sonal malhotra6y ago
{"Invalid object name 'dbo.Patients'."}
Sundaram Subramanian6y ago
Then still getting the same error ?.
sonal malhotra6y ago
then there is no patients n no apppointments shown in db ..what to do
Sundaram Subramanian6y ago
Those Patient IDs are referenced in Child table Appointments. Delete that Patient ID from the Appointment and then delete from Patient Table. It works.
sonal malhotra6y ago
deleted patients tbl but error shown can i put add migrations in cconsole?
Sundaram Subramanian6y ago
Are you trying to delete value from the Patient Table ?.
sonal malhotra6y ago
patients is primary key... in appointment table there is fk patientsid ..please explain what to do n how to correct
Sundaram Subramanian6y ago
You are trying to delete a Foreign key values PatientID in the table. You cannot delete a foreign key column when it is referenced in other tables. Correct it, it will works fine.