I have developed a simple application to test multiselect using EF6 and Sql. List, Create, Edit, and Details actions work. I get an error with delete
The DELETE statement conflicted with the REFERENCE constraint "FK__TaskTeam__TaskId__3B75D760". The conflict occurred in database "multiselect", table "dbo.TaskTeam", column 'TaskId'.
Delete action:
public ActionResult DeleteConfirmed(int id)
{
var task = db.Tasks.Find(id);
db.Tasks.Remove(task ?? throw new InvalidOperationException());
db.SaveChanges();
return RedirectToAction("Index");
}
Entity Model:
public partial class DAL : DbContext
{
public DAL()
: base("name=DALEntitites2")
{
}
public virtual DbSet<Tasks> Tasks { get; set; }
public virtual DbSet<Team> Team { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Tasks>()
.HasMany(e => e.TeamMembers)
.WithMany(e => e.Tasks)
.Map(m => m.ToTable("TaskTeam").MapLeftKey("TaskId").MapRightKey("TeamId"));
}
}