Why is it that when I delete or edit the record from table x it is also removed from table y?

Question

I have a system in ASP MVC with C# using Entity framework.

I have the table Pedidos and Agenda.

On the table agenda I have a column with the id of the request.

When the order is canceled, I have to remove from the table Agenda to release a schedule for a new order.

The problem is that when you remove the row from the table Agenda with request 13(for example), in the table pedido the same is removed also.

I already did a search and found something on Cascade in the SQL, but it’s not activated.

What can it be?

Follows code:

 public partial class ifixEntities : DbContext
{
    public MyEntities()
      : base("name=MyEntities")
    {

    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
        modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>();

        modelBuilder.Entity<Agenda>().HasOptional<Pedido>(s => s.Pedido).WithMany().WillCascadeOnDelete(false);                        
    }
}

Answer 1

It’s called Cascade Delete and is a standard behavior of the Entity Framework.

You can also put some general rules, and not just specific for each model.

Ex:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>()
    modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>()
}

So you remove on all models.

Answer 2

example to remove Cascade delete

public class SchoolContext<: DbContext
{
    public SchoolContext():base("MySchool")
    {
                }

    public DbSet<Student> Students { get; set; }
    public DbSet<Standard> Standards { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Student>()
            .HasOptional<Standard>(s => s.Standard)
            .WithMany()
            .WillCascadeOnDelete(false);
    }
}

source: http://www.entityframeworktutorial.net/code-first/cascade-delete-in-code-first.aspx