When using data annotations with EF4.1 RC is there an annotation to cause cascade deletes?
public class Category { public int Id { get; set; } [Required] public string Name { get; set; } public ICollection<Product> Products { get; set; } } public class Product { public int Id { get; set; } public string Name { get; set; } public Category Category { get; set; } }
Using this model the constraint generated is:
ALTER TABLE [Product] ADD CONSTRAINT [Product_Category] FOREIGN KEY ([Category_Id]) REFERENCES [Categorys]([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION;
If not how is it achieved?
Putting required on the Product table Category relationship field solves this
public class Product { public int Id { get; set; } public string Name { get; set; } [Required] //<======= Forces Cascade delete public Category Category { get; set; } }
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With