Specify a cascading delete for parent / child relationships?

Question

Model:

public class MenuItem { public Guid Id {get;set;} public virtual Guid? ParentMenuItemId {get;set;} public virtual MenuItem ParentMenuItem {get;set;} public virtual ICollection<MenuItem> ChildMenuItems {get;set;} }

current mapping:

HasOptional(m => m.ParentMenuItem).WithMany(p => p.ChildMenuItems).HasForeignKey(m => m.ParentMenuItemId);

I tried adding the WillCascadeOnDelete(true), but I got an error. How should I update my mapping to allow for cascading deletes? So, If I delete a Parent, all the children will be deleted. Do I have to do this manually?

What error are you receiving?

Justin Pihony
– Justin Pihony

2012-02-24 16:20:37 +00:00
Commented Feb 24, 2012 at 16:20 — Justin Pihony
– Justin Pihony, Commented Feb 24, 2012 at 16:20

Justin Pihony · Accepted Answer · 2012-02-24 16:01:03Z

In your model, just look at the association's properties. There is an OnDelete that you can set to Cascade. The XML should look like this:

<OnDelete Action="Cascade" />

Collectives™ on Stack Overflow

Specify a cascading delete for parent / child relationships?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related