Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I use Data Annotations to perform a Cascade Delete with Entity Framework 4.1 RC?

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?

like image 838
Bender Avatar asked Apr 06 '11 15:04

Bender


1 Answers

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; } } 
like image 117
Bender Avatar answered Oct 02 '22 20:10

Bender