Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?

by

You can use the fluent api to specify the actions the error message suggests.

In your Context:

protected override void OnModelCreating( DbModelBuilder modelBuilder )
{
        base.OnModelCreating(modelBuilder);
        modelBuilder.Entity<aspnet_UsersInRoles>().HasMany(i => i.Users).WithRequired().WillCascadeOnDelete(false);
}

Note that you have not included the definition for the table aspnet_UsersInRoles so this code may not work.

Another option is to remove all CASCADE DELETES by adding this 

modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();

If you need more info about configuring relationships with the fluent api I suggest http://msdn.microsoft.com/en-US/data/jj591620

More Related Contents:

  1. MVC3 and Entity Framework
  2. ASP.NET Identity DbContext confusion
  3. How can I force entity framework to insert identity columns?
  4. How to “warm-up” Entity Framework? When does it get “cold”?
  5. How do I add ROW_NUMBER to a LINQ query or Entity?
  6. How and where to call Database.EnsureCreated and Database.Migrate?
  7. How to warm up an ASP.NET MVC application on IIS 7.5?
  8. thread messaging system database schema design
  9. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  10. It has a DefiningQuery but no InsertFunction element… err
  11. Entity Framework 4 – Update database schema from model. Without wiping the table data
  12. Entity framework context as static
  13. Unable to Retrieve Metadata
  14. Difference between DropDownlist or DropDownListFor Html helper
  15. How to combine using Membership API with own application related data?
  16. Unit-testing .ToListAsync() using an in-memory
  17. Unable to create an object of type ‘[DBContext’s Name]’. For the different patterns supported at design time [closed]
  18. Entity Framework v2 doesn’t support sql 2000?
  19. Is it possible to change the username with the Membership API
  20. How to support HTTP OPTIONS verb in ASP.NET MVC/WebAPI application
  21. Remove HTML or ASPX Extension
  22. How to make a section of an image a clickable link
  23. Session Fixation in ASP.NET
  24. In asp.net mvc is it possible to make a generic controller?
  25. Where does ASP.NET virtual path resolve the tilde “~”?
  26. Adding sub-directory to “View/Shared” folder in ASP.Net MVC and calling the view
  27. “Context cannot be used while the model is being created” exception with ASP.NET Identity
  28. Cache VS Session VS cookies?
  29. What is an HttpHandler in ASP.NET
  30. Default redirect for Error 404

Leave a Comment