How to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”

In code first once i got an error

Introducing FOREIGN KEY constraint ‘FK_dbo.Regions_dbo.Countries_CountryId’ on table ‘Regions’ 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.

After some searches I found many options to solve this issue. One of simple and global solution is add modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>() in OnModelCreating method of your DataContext file as follow:

public class YourDataContext : DbContext
    public DbSet<Country> Countries{ get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s