Getting Error while deleting record in ASP.Net website using Entity Framework

Question

I'm using Entity Framework in asp.net in Visual Studio 2012. I'm just learning these stuffs. I followed this tutorial

Just created the grid and I run the web site, everything is fine except the delete operation. When I click delete it shows me an error like this:

enter image description here

Would somebody tell me why I'm getting this error and how to rectify this. . .

Thanks in advance

1st run your Delete query On sql server. Error show their is relationship error, — Satinder singh
– Satinder singh, Commented Dec 27, 2012 at 10:16
@satindersingh In Sql server it executes perfectly if i delete the person of id '3', the row gets deleted, It works in SQL Server — ggsmartboy
– ggsmartboy, Commented Dec 27, 2012 at 10:21
Delete stmt confilicted with reference constraint **Fk_courseInstructo_person** this msg indicates their is Primary/Foreign key relationship. — Satinder singh
– Satinder singh, Commented Dec 27, 2012 at 10:29

hridya pv · Accepted Answer · 2012-12-27 10:27:35Z

3

Your answer for your question is given in your tutorial. (Applicable only if you are using the same tables and same constraints) under "Revising EntityDataSource Control Markup to Improve Performance"

The Delete button also works. Click delete for a row that has an enrollment date and the row disappears. (Rows without an enrollment date represent instructors and you may get a referential integrity error. In the next tutorial you'll filter this list to include just students.)

You are getting referential error means you haven't used cascade in delete operation so when you delete a row in person table,as the same column is referenced in student grade table. so delete won't take place. use cascade - ON DELETE CASCADE.

answered Dec 27, 2012 at 10:27

hridya pv

1,0591 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Neil Thompson Over a year ago

+1 for pointing back to the answer in the tutorial. Good spot.

bummi · Accepted Answer · 2012-12-27 10:17:33Z

1

Seems as if you want to delete a person from CourseInstructor which is refereced by school.

answered Dec 27, 2012 at 10:17

bummi

27.4k14 gold badges67 silver badges105 bronze badges

Comments

Neil Thompson · Accepted Answer · 2012-12-27 10:27:56Z

0

This is a pretty clear error message that a quick google would help you resolve faster.

Table CourseInstructor has a foreign key relationship with Table Person. In your EF diagram you can see this as a relationship (a line between two entities).

The database will not let you delete a Person while a CourseInstructor still has a reference to the Person, so you need to delete the relevant CourseInstructor first, ideally as part of a transaction.

If you are really struggling look up 'referential integrity' and 'referential integrity in entity framework'.

Hopefully this helps some.

answered Dec 27, 2012 at 10:27

Neil Thompson

6,4652 gold badges33 silver badges55 bronze badges

Collectives™ on Stack Overflow

Getting Error while deleting record in ASP.Net website using Entity Framework

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related