【无标题】

C# WPF 问题记录

            var customerToRemove = db.Customers
                .Where(c => c.Id == (int)customerId) //筛选特定customerId
                .Include(c => c.Appointments) //外键连接
                .FirstOrDefault();
            db.Customers.Remove(customerToRemove);//删除筛选后结果
            db.SaveChanges();//提交保存改变

根据customerId筛选删除特定Customer 并使用 Include联查外键数据，需要级联删除Customer对应的外键表数据
修改如下

 entity.HasOne(d => d.Customer)
            .WithMany(p => p.Appointments)
                .HasForeignKey(d => d.CustomerId)
               // .OnDelete(DeleteBehavior.ClientSetNull)
                .OnDelete(DeleteBehavior.Cascade)//开启级联删除即可解决问题
                .HasConstraintName("FK_Appointments_Customers");

`