How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?

by

Possible reason why you don’t get cascading delete is that your relationship is optional. Example:

public class Category
{
    public int CategoryId { get; set; }
}

public class Product
{
    public int ProductId { get; set; }
    public Category Category { get; set; }
}

In this model you would get a Product table which has a foreign key to the Category table but this key is nullable and there is no cascading delete setup in the database by default.

If you want to have the relationship required then you have two options:

Annotations:

public class Product
{
    public int ProductId { get; set; }
    [Required]
    public Category Category { get; set; }
}

Fluent API:

modelBuilder.Entity<Product>()
            .HasRequired(p => p.Category)
            .WithMany();

In both cases cascading delete will be configured automatically.

If you want to have the relationship optional but WITH cascading delete you need to configure this explicitely:

modelBuilder.Entity<Product>()
            .HasOptional(p => p.Category)
            .WithMany()
            .WillCascadeOnDelete(true);

Edit: In the last code snippet you can also simply write .WillCascadeOnDelete(). This parameterless overload defaults to true for setting up cascading delete.

See more on this in the documentation

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  3. How do I detach objects in Entity Framework Code First?
  4. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  5. Entity framework code-first null foreign key
  6. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  7. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  8. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  9. Ignoring a class property in Entity Framework 4.1 Code First
  10. Entity Framework 6 Code first Default value
  11. EntityFramework code-first custom connection string and migrations
  12. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  13. Debug code-first Entity Framework migration codes
  14. Cascading deletes with Entity Framework – Related entities deleted by EF
  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 map table splitting in EF Code First?
  18. How to create index in Entity Framework 6.2 with code first
  19. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  20. Entity Framework 4.1 default eager loading
  21. mapping private property entity framework code first [duplicate]
  22. What is the syntax for self referencing foreign keys in EF Code First?
  23. How to create index in Entity Framework 6.2 with fluent configuration
  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. Using the Entry().CurrentValues.SetValues() is not updating collections
  28. Model First with DbContext, Fails to initialize new DataBase
  29. Getting exact error type in from DbValidationException
  30. Entity framework code first delete with cascade

Leave a Comment