时间戳

首页 > 解决方案 > 如何在实体框架中对外键应用级联删除

c# - 如何在实体框架中对外键应用级联删除

问题描述

我创建了两个名为 Customer 和 destination 的表格。CustomerCode 是 Customer 中的主键，外键是 Destination 。当我删除客户时，目的地将被删除。

public class tblCustomerDetails
{
    [Key]
    public string CustomerCode { get; set; }
    public string CustomerName { get; set; }
}

public class tblDestinationDetails
{
    [Key]
    public string DestinationCode { get; set; }
    [ForeignKey("tblCustomerDetails")]
    public string CustomerCode { get; set; }
    public tblCustomerDetails tblCustomerDetails { get; set; }
    public string DestinationName { get; set; }
}

public class tblOrderDetails
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Key]
    public int SrNo { get; set; }

    public int OrderNo { get; set; }

    [ForeignKey("tblCustomerDetails")]
    public string CustomerCode { get; set; }
    public tblCustomerDetails tblCustomerDetails { get; set; }

    [ForeignKey("tblDestinationDetails")]
    public string DestinationCode { get; set; }
    public tblDestinationDetails tblDestinationDetails { get; set; }
}

标签： c#entity-framework-6cascading-deletes

解决方案

您可能的模型将是

public class Customer 
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int CustomerCode { get; set; }
    public virtual Destination destination { get; set; }//relationship with Destination
}
public class Destination 
{

    public virtual Customer customer { get; set; }//relationship with Customer 
    [Key, ForeignKey("User")]
    public int CustomerCode { get; set; }
}

您需要使用 fluent API 并在 DBContext 中添加以下代码

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{   
    modelBuilder.Entity<Customer>()
        .HasOptional(d => d.Destination)
        .WithOptionalDependent()
        .WillCascadeOnDelete(true);
}

推荐阅读