asp.net mvc (Migration)

Question

I crete table in asp.net mvc but when i crete the migration this error message show

Introducing FOREIGN KEY constraint 'FK_dbo.DailyTransactions_dbo.Contracts_ContractId' on table 'DailyTransactions' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint. See previous errors.

this is DailyTransactions table :

 public class DailyTransactions
{
    [Key]
    public int DailyTransactions_Id { get; set; }

    public double Account { get; set; }

    public string Account_Name { get; set; }

    public double Debit { get; set; }

    public double Credit { get; set; }

    public DateTime Date { get; set; }

    public string Remarks { get; set; }

    public int CustomerId { get; set; }

    [ForeignKey("CustomerId")]
    public virtual Customers customers { get; set; }

    public int ContractId { get; set; }

    [ForeignKey("ContractId")]
    public virtual Contracts contracts { get; set; }

}

and this contract table :

 public class Contracts
{
    [Key]
    public int Contracts_Id { get; set; }

    public int Contract_Num { get; set; }

    public DateTime Contract_Start { get; set; }

    public DateTime Contract_End { get; set; }

    public string Status { get; set; }

     public string TypeOfRent { get; set; }

    public double AmountOfRent { get; set; }

     public double Total { get; set; }

    public int CustomerId { get; set; }

      [ForeignKey("CustomerId")]
    public virtual Customers customers { get; set; }

      public int sectionsId { get; set; }

      [ForeignKey("sectionsId")]
      public virtual Sections sections { get; set; }



}

Try adding WillCascadeOnDelete(false) in modelBuilder.Entity<DailyTransactions>(), because you don't have any [Required] attribute annotations. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Feb 27, 2019 at 8:18
You need to add it inside OnModelCreating method (I assumed you're using Code First here). Also you may want to try modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>(); too. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Feb 27, 2019 at 8:29
Possible duplicate of Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why? — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Feb 27, 2019 at 8:34

StepUp · Accepted Answer · 2019-02-27 08:44:20Z

1

Try to turn off CascadeDelete for DailyTransactions and Contracts:

modelBuilder.Entity<DailyTransactions>()
    .HasRequired(c => c.Contracts)
    .WithMany()
    .WillCascadeOnDelete(false);

For example:

public class YourDBContext: DbContext 
{
    public YourDBContext(): base() 
    {
    }



    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<DailyTransactions>()
            .HasRequired(c => c.Contracts)
            .WithMany()
            .WillCascadeOnDelete(false);
    }
}

edited Feb 27, 2019 at 8:44

answered Feb 27, 2019 at 8:32

StepUp

38.5k16 gold badges95 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Software Developer Over a year ago

OK i will try .

StepUp Over a year ago

@SoftwareDeveloper I am glad to help you!:)

Collectives™ on Stack Overflow

asp.net mvc (Migration)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related