CODEWITHSUNDEEP
c#entity-framework
Manvinder
Manvinder

Reputation: 4587

How do I delete all the entities related to a specific entity?

I am using Entity Framework 4.0 and I want to delete all the entities that are pointed to by the navigation property on an entity. How can I do this?

Upvotes: 1

Views: 622

Answers (2)

Magix
Magix

Reputation: 1

I'm not sure if I have understood your problem. but as I know .clear() method clears and removes all the navigation properties like Orders.clear()

Upvotes: 0

Eranga
Eranga

Reputation: 32437

You are trying to solve the problem in the wrong layer. You need to reconsider your database design specially how you maintain the referential integrity.

You need to set the "CASCADE DELETE"s of the foreign keys and reflect that in your Entity Model. Then the database will make the necessary changes to maintain the referential integrity when you delete that entity.

Upvotes: 3

Related Questions