Entity framework code first delete with cascade

by

You mentioned EF code first which means EF 4.1 but you have shown example of deleting object in EF 4. Correct approach to delete object in EF 4.1 without loading it from database is:

var category = new Category() { CategoryId = 1 };
context.Categories.Attach(category);
context.Categories.Remove(category);
context.SaveChanges();

If you didn’t change anything in configuration of defalut conventions it will also delete all related products because OneToManyCascadeDeleteConventions ensures that all one-to-many relations are created with ON CASCADE DELETE. There will be no additional roundtrips to database – only single DELETE statement for Category with Id = 1.

The different situation can occure if you want to delete fully loaded Category (with loaded Products navigation property) in such case EF will create separate delete statement for each Product so you will have N+1 roundtrips to database where N is number of products in category. Here is how cascade delete works in EF. It is related to entity designer but described principles are the same.

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. Unique Key constraints for multiple columns in Entity Framework
  4. Entity Framework 6 Code first Default value
  5. EntityFramework code-first custom connection string and migrations
  6. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  7. Improve navigation property names when reverse engineering a database
  8. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  9. How do I detach objects in Entity Framework Code First?
  10. EF5 Code First Enums and Lookup Tables
  11. Debug code-first Entity Framework migration codes
  12. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  13. Entity framework code-first null foreign key
  14. Entity Framework loading child collection with sort order
  15. How do I singularize my tables in EF Code First?
  16. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  17. How to create index in Entity Framework 6.2 with code first
  18. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  19. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  20. mapping private property entity framework code first [duplicate]
  21. What is the syntax for self referencing foreign keys in EF Code First?
  22. How to create index in Entity Framework 6.2 with fluent configuration
  23. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  24. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  25. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  26. EF Code First foreign key without navigation property
  27. Entity Framework Code First Using Guid as Identity with another Identity Column
  28. LINQ To Entities + Include + Anonymous type issue
  29. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  30. Can anyone spot why I keep getting this error testing the EF 5 beta

Leave a Comment