May cause cycles or multiple cascaded paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints

Question

May cause cycles or multiple cascaded paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints

Navigation

#1 by (1 votes)
#2 by (0 votes)

4

I have a class that will have two FKs pointing to the same table, so the Entity Framework returns the error:

Can cause cycles or multiple cascading paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

[ForeignKey("TestePaiId")]
public virtual Teste TestePai { get; set; }
public int TestePaiId { get; set; }

[ForeignKey("TesteFilhoId")]
public virtual Teste TesteFilho{ get; set; }
public int TesteFilhoId{ get; set; }

c# entity-framework

asked by anonymous 24.05.2017 / 01:48

2 answers

How to check availability of domains (whois) with php? Return Dowload Excel via MVC Controller

score 1 · Answer 1

1

I solved using this code:

modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConve‌ntion>();

within OnModelCreating

24.05.2017 / 23:18

score 0 · Answer 2

In this case, I believe the correct one is to use the code below in the override function "OnModelCreating", within its class that inherits from DbContext:

modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();

Because the relationship is one-to-one.