0

I have a record of categories for a store now I want set relationship between 2 categories I mean, I want to put these categories under each other This is how I wrote the model:

public class Categories
{
.
.

[ForeignKey("FatherId")]
public Categories Father { get; set; }         
 public int FatherId { get; set; }
.
.
}

But I got this error: Introducing FOREIGN KEY constraint 'FK_Categories_Categories_FatherId' on table 'Categories' 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 or index. See previous errors.

mohammad rahimi
  • 148
  • 1
  • 1
  • 11
  • Does this answer your question? [Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why?](https://stackoverflow.com/questions/17127351/introducing-foreign-key-constraint-may-cause-cycles-or-multiple-cascade-paths) – David Browne - Microsoft Dec 05 '20 at 14:29
  • A self reference is always cyclic, potentially. – Gert Arnold Dec 05 '20 at 16:31

0 Answers0