Delete the foreign key data when the data in the foreign table is deleted

ado.net-entity-data-model asp.net-mvc entity-framework-6 linq linq-to-entities

Question

I have 2 database tables, and I want when I delete a data in the table where the foreign key is pointing (where the primary key is), the foreign key pointing to that data also be deleted.

    [HttpPost, ActionName("Delete")]
    [ValidateAntiForgeryToken]
    public async Task<ActionResult> DeleteConfirmed(int id)
    {

        Report report = await db.Reports
            .Include(i => i.RepFilters)
            .Where(i => i.ID == id).SingleAsync();

        db.Reports.Remove(report);

        await db.SaveChangesAsync();
        return RedirectToAction("Index");
    }

The foreign key is not nullable.

enter image description here (the error I get)

How to do/fix that? (help me make the right title)

1
1
7/7/2016 1:27:24 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

It can be possible when .Net or EF generated the code for your context that the 

.WillCascadeOnDelete()

was set to false, so just change it to true and try if it works.

1
7/8/2016 12:58:56 PM

Popular Answer

If you don't want to do it through the SQL server, you'll have to load all the child objects in the db context and delete them.

AD.Net

Related Questions

Cascade remove issues in Entity Framework - Foreign key set to null

I have the following Model which I mapped with the Entity Framework: Mitglied -> Auftrag -> Teilprojekt...I have set up everything in the database with foreign keys and "on delete cascade". If I perform some tests on the database everything works fine. The problem arises as soon as I use the Entity Framework to add and especially delete objects. Co...
c# cascading-deletes entity-framework
asked by Manfred

How to load data from tables with foreign keys in entity framework

In EF4 lazy loading is included and is on by default. ...No such luck in prior versions: You may need to add an .Include() to fetch the other data automatically (eager loading) or call Load() on the references to load them (manually)....If the reference table was say "Details" you would do ......var featuredOffers = context.Hosters_FeaturedOffer.I...
asp.net dynamic-data entity-framework linq-to-entities
asked by Ian Mercer

From a foreign key in a table, EF does not construct a foreign key association.

I have a table tblEvent and another table tblContact. There is a field ContactID in tblEvent that is linked by a foreign key to ContactID in tblContact. I've triple checked; the foreign key is in the database....The Entity Framework model DOES NOT generate a navigation property and foreign key association for it as it does for the other foreign k...
entity-framework
asked by rsteckly

EF Code First allows cascading deletes without exposing foreign keys.

When performing a delete of a one-many relationship without exposing the foreign key, EF deletes the parent record and tries to null the foreign key on the child records. This of course causes an error because the foreign key is not nullable. Adding the foreign key to the child class overrides this behavior, but I'd rather not expose it. ...For exa...
cascading-deletes code-first entity-framework one-to-many
asked by Craig M

In Entity Framework, how to delete record with foreign key constraint?

I have a method to delete a "project" record in the database, and all the "option items" associated with it....public bool DeleteProjectById(int id) { using (DbContext db = new DbContext(ConfigHelper.Instance().ConnectionString)) { try { foreach (var entity in db.ProjectOptionItems.Where(o => o.ProjectId == id)) ...
asp.net asp.net-mvc entity-framework
asked by Ronald

Entity Framework retrieve data from table with foreign key

You are looking for the ....Include()... statement...http://msdn.microsoft.com/en-us/data/jj574232.aspx...var role = PREntitiy.Roles.Include(r=>r.Permission).Where(r => r.qRole == TxtRole.Text) ...I don't have all your classes, so that Permission property may be incorrect....You would access the properties from each class using dot notation like no...
c# entity-framework linq linq-to-entities sql
asked by BlackICE

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...
entity-framework entity-framework-6 insert
asked by WerkingWill

Entity Framework Error Deleting Entity with Foreign Key Relationship

I am having a problem deleting some entities due to a foreign key relationship. I understand the following error message and have been doing everything I can think of to delete the entities without incurring this error:...The DELETE statement conflicted with the REFERENCE constraint "FK_QuizUserAnswer_QuizWithQuestion". The conflict occurred in ...
entity-framework entity-framework-6 poco
asked by onefootswill

To delete a row from a table of only foreign keys using Entity Framework

If your entity class (I guess ...User...), has navigation properties of type ...ICollection<Licence>... by removing Licence from this collection you are actually removing items from ...UserLicense... table. This is how Entity Framework handles many-to-many relationships in databases.
asp.net-mvc c# entity-framework-6 linq
asked by Paweł Mach

Fetch foreign key table data

In Entity Framework 6 you can do it like this:...using (DatabaseContext context = new DatabaseContext()) { return context.JobDetails.Include(x => x.Likes).ToList(); }
asp.net-core c# entity-framework-6 entity-framework-core javascript
asked by Alexander Grasberger

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow