How to delete a row in a table and all its foreign key relationships with Entity Framework?

Question

I have table called "Categories"

Which has a relationship with this table

How can I for a example delete the "ForumTest" category and all the threads related to it in the second table?

EDIT: This is my current code that only works with categories without relationships

[HttpPost]
public ActionResult DeleteCategory(int? id)
{
    Category category = db.Categories.Find(id);

    db.Threads.RemoveRange(category.Threads);
    db.Categories.Remove(category);
    db.SaveChanges();

    return RedirectToAction("Categories");
}

this will help : http://stackoverflow.com/questions/3656099/how-to-delete-rows-in-tables-that-contain-foreign-keys-to-other-tables — dhS, Aug 20 '16 at 17:35
You want to do this one time or every time You delete a row from Catagories? — Whencesoever, Aug 20 '16 at 17:36

score 1 · Answer 1 · answered Aug 20 '16 at 18:00

You need to config your relationship with cascading delete. Override OnModelCreating method in your context and add this:

modelBuilder
    .Entity<Thread>()
    .HasRequired(s => s.Category)
    .WithMany(r => r.Threads)
    .HasForeignKey(s=>s.CategoryId)
    .WillCascadeOnDelete(true);

score 0 · Answer 2 · answered Aug 22 '16 at 10:54

Category category = db.Categories.Find(id);

db.Threads.RemoveRange(category.Threads);
db.Categories.Remove(category);
db.SaveChanges();

After this Remove all related table data like.

var categoryDetail = relatedtable.Find(id);


    db.relatedtable.RemoveAll(categoryDetail);
    db.SaveChanges();

How to delete a row in a table and all its foreign key relationships with Entity Framework?

2 Answers2