Migration - FOREIGN KEY constraint

Hi, I working with Code First when I run the migration I get error.

Introducing FOREIGN KEY constraint 'FK_dbo.Users_dbo.Campaigns_CampaignID' on table 'Users' 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.

Please, I need help, I don't understand why this error happens.

Thanks,

public class Message
{
public int ID { get; set; }
public string Content { get; set; }
public string Timestamp { get; set; }
public int UserID { get; set; }
public virtual User User { get; set; }
public int RoomID { get; set; }
public virtual Room Room { get; set; }
}

public class Room
{
public int ID { get; set; }
[MaxLength(200)]
public string RoomKey { get; set; }
[StringLength(30, MinimumLength = 3)]
public string Name { get; set; }
public int UserCreator { get; set; }
public virtual User User { get; set; }
public int CampaignID { get; set; }
public virtual Campaign Campaign { get; set; }
public virtual ICollection Messages { get; set; }
}

public class Company
{
public int ID { get; set; }
[StringLength(30, MinimumLength = 3)]
public string Name { get; set; }
public virtual ICollection Campaigns { get; set; }
}

public class Campaign
{
public int ID { get; set; }
[StringLength(50, MinimumLength = 3)]
public string Name { get; set; }
public int CompanyID { get; set; }
public virtual Company Company { get; set; }
public virtual ICollection Users { get; set; }
public virtual ICollection Rooms { get; set; }
}

public class City
{
public int ID { get; set; }
[StringLength(50, MinimumLength = 3)]
public string Name { get; set; }
public virtual ICollection Users { get; set; }
}

public class User
{
public int ID { get; set; }
[StringLength(50, MinimumLength = 3)]
public string UserName { get; set; }
public string Password { get; set; }
[StringLength(50, MinimumLength = 3)]
public int CityID { get; set; }
public virtual City City { get; set; }
public int CampaignID { get; set; }
public virtual Campaign Campaign { get; set; }
public int RoomID { get; set; }
public virtual Room Room { get; set; }
public bool Status { get; set; }
public DateTime RegisterDate { get; set; }
public int UserCreator { get; set; }
}

The ID field of Message and Capain tables should be primary key like
public class Company
{
[Key]
public int ID { get; set; }
}
public class Room
{
public int ID { get; set; }
[MaxLength(200)]
public string RoomKey { get; set; }
[StringLength(30, MinimumLength = 3)]
public string Name { get; set; }
public int UserCreator { get; set; }
public virtual User User { get; set; }
[ForeignKey("Campaign")] // here the capain is the table name
public int CampaignID { get; set; }
[ForeignKey("ID")] //Here ID is the field of capain table
public virtual Campaign Campaign { get; set; }
[ForeignKey("ID")] //Here the ID is the Message table
public ICollection Messages { get; set; }
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
1. The ID field of Message and Capain tables should be primary key like
3. public class Company
4. {
5. [Key]
6. public int ID { get; set; }
8. }
12. public class Room
13. {
14. public int ID { get; set; }
15. [MaxLength(200)]
16. public string RoomKey { get; set; }
17. [StringLength(30, MinimumLength = 3)]
18. public string Name { get; set; }
20. public int UserCreator { get; set; }
21. public virtual User User { get; set; }
22. [ForeignKey("Campaign")] // here the capain is the table name
23. public int CampaignID { get; set; }
24. [ForeignKey("ID")] //Here ID is the field of capain table
25. public virtual Campaign Campaign { get; set; }
26. [ForeignKey("ID")] //Here the ID is the Message table
27. public ICollection Messages { get; set; }
28. }