Good afternoon, I have the following relational diagram
I have a problem, when deleting a record from the table Tbl_Horarios does not leave me, because it is related to more than one record in the Tbl_DetalleHorario table.
How can I do so that when I delete a record from the Tbl_Horarios table I also delete all the records that are related from the Tbl_DetalleHorario table with the record I want to delete from the Tbl_Horarios table.
I'm using entity framework on asp.net mvc c #
Look at this example of a context class:
public class AppContext : DbContext
{
public DbSet<Trabajador> Trabajadores { get; set; }
public DbSet<Area> Areas { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Trabajador>()
.HasRequired(d => d.Area)
.WillCascadeOnDelete(true);
}
}
In this way you define that when you delete an Area, the Workers who belong to it will also be eliminated.