I have added Cascade Delete to my database but I do not see this update in my model. How do I make sure that my model has cascade delete enabled for a database first model?
2
-
Sorry. I found it under the edmx model file. Dont know how I missed it.Nate– Nate2011-07-20 16:04:48 +00:00Commented Jul 20, 2011 at 16:04
-
Could you explain where you found this option as it's something I might need to do too?Chris Snowden– Chris Snowden2011-07-20 16:07:58 +00:00Commented Jul 20, 2011 at 16:07
Add a comment
|
1 Answer
If the cascade delete is set on the database then you have nothing to worry about. Deleting the main Object would translate on
- EF telling the DB "delete entity -foo-"
- DB checking all the dependencies for table -foo(s)-
- DB deleting first all records for -foo-.ID in all dependent tables
- DB finally deleting -foo-.ID in table -foo(s)-
It would be more cumbersome if you only had the cascade delete on the Model but not the Database, as that would mean the EntityFramework try to figure out all of the above on runtime.
If you really want to ensure the cascade delete, you could enable it in both layers, although it doesn't sound like a good idea to me as some data "might disappear" (because it was cascade deleted) from the EF state manager.
