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

.net, entity-framework, entity-framework-4.1

Solution

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; }
}

Problem

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?

Original source

Related problems