I got an error whenever I run migration in entity framework core

Question

1.00/5 (1 vote)

See more:

Introducing FOREIGN KEY constraint 'FK_PMS_UserRoles_PMS_Users_UserId' on table 'PMS_UserRoles' 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.

What I have tried:

public class PMS_Company : IBaseEntity
    {
        public PMS_Company()
        {
            Users = new HashSet<PMS_User>();
            Roles = new HashSet<PMS_Role>();
          
        }
       
        public int Id { get; set; }
        public string CompanyName { get; set; }
        public string RegistrationNo { get; set; }
        public string OwnerName { get; set; }
        public string Logo { get; set; }
        public string Address { get; set; }
        public string PhoneNumber { get; set; }
        public bool IsActive { get; set; }
        public int CreatedBy { get; set; }
        public DateTime CreatedOn { get; set; }
        public int? EditedBy { get; set; }
        public DateTime? EditedOn { get; set; }
 
 
        public IReadOnlyCollection<PMS_User> Users { get; set; }
        public IReadOnlyCollection<PMS_Role> Roles { get; set; }
       
    }
public class PMS_User : IBaseEntity
    {
        public PMS_User()
        {
          UserRoles = new HashSet<PMS_UserRole>();
        }
        public int Id { get ; set ; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string Email { get; set; }
        public string Paswword { get; set; }
        public string salt { get; set; }
        public DateTime ExpireDate { get; set; }
        public bool IsActive { get ; set ; }
        public int CreatedBy { get ; set ; }
        public DateTime CreatedOn { get ; set ; }
        public int? EditedBy { get ; set ; }
        public DateTime? EditedOn { get ; set ; }
 
        public int CompanyId { get; set; }
        public PMS_Company Company { get; set; }
 
        public IReadOnlyCollection<PMS_UserRole> UserRoles { get; set; }
    }
 
  public class PMS_UserRole 
    {
        
        public int UserId { get; set; }
        public PMS_User User { get; set; }
        public int RoleId { get; set; }
        public PMS_Role Role { get; set; }
    }
 
  public class PMS_Role : IBaseEntity
    {
        public PMS_Role()
        {
           UserRoles = new HashSet<PMS_UserRole>();
        }
        public int Id { get ; set; }
        public string RoleName { get; set; }
        public string RoleNameN { get; set; }
        public bool IsActive { get; set; }
        public int CreatedBy { get; set; }
        public DateTime CreatedOn { get; set; }
        public int? EditedBy { get; set; }
        public DateTime? EditedOn { get; set; }
 
        public int CompanyId { get; set; }  
        public PMS_Company Company { get; set; }
 
       public IReadOnlyCollection<PMS_UserRole> UserRoles { get; set; }
        
    }
 
 public class UserRolesConfiguration : IEntityTypeConfiguration<PMS_UserRole>
    {
        public void Configure(EntityTypeBuilder<PMS_UserRole> builder)
        {
            builder.ToTable("PMS_UserRoles");
 
            builder.HasKey(x => new { x.RoleId, x.UserId });
            builder.HasOne(ur => ur.Role)
                .WithMany(x => x.UserRoles)
                .HasForeignKey(x => x.RoleId);
            builder.HasOne(ur => ur.User)
                .WithMany(x => x.UserRoles)
                .HasForeignKey(x => x.UserId);
        }
    }

Posted 26-Aug-19 8:10am

awaisshabir

Updated 27-Aug-19 8:07am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2019-08-26T10:33:00

Quote:
Introducing FOREIGN KEY constraint 'FK_PMS_UserRoles_PMS_Users_UserId' on table 'PMS_UserRoles' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

The error itself is explaining itself, the FOREIGN KEY being created in this migration is likely to cause a cycle; connection in the tables.

It is a good approach to re-evaluate the database schema, and see how this is being caused. You can try reading documentation for these causes to understand what they are, like here: .net - Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why? - Stack Overflow[^]

Richard Deeming · Answer 2 · 2019-08-27T08:07:00

The key is is the phrase "multiple cascade paths". This means that deleting one entity could cause another entity to be deleted via multiple relationships.

In this case, deleting a PMS_Company will delete both the users and the roles in that company. Deleting the users will delete the associated PMS_UserRole entities. Deleting the roles will delete the associated PMS_UserRole entities. Therefore, there are two paths by which a single delete could cause a PMS_UserRole to be deleted, which SQL Server does not allow.

Error message 1785 occurs when you create a FOREIGN KEY constraint that may cause multiple cascade paths[^]

It's an annoying limitation, but it's one you have to live with. You will have to change one or more of the relationships to not cascade on delete. When you want to delete the parent entity, you will need to manually delete the related entities instead of relying on the cascade delete behaviour.

For example:

C#

builder.HasOne(ur => ur.Role)
    .WithMany(x => x.UserRoles)
    .HasForeignKey(x => x.RoleId)
    .OnDelete(DeleteBehavior.None);

Cascade Delete - EF Core | Microsoft Docs[^]

I got an error whenever I run migration in entity framework core

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0