public class Comment { public virtual int CommentId { get; set; } public virtual string Content { get; set; } public virtual int? LikesCount { get; set; } public virtual Int64? Created { get; set; } public virtual int NodesId { get; set; } public virtual string UsersId { get; set; } public ICollection<Votes> Votes { get; set; } public Nodes Nodes { get; set; } public ApplicationUsers Users { get; set; } } public class Nodes { public virtual int NodesId { get; set; } public virtual string Type { get; set; } public virtual string Subject { get; set; } public virtual string Content { get; set; } public virtual int? GroupsId { get; set; } public virtual int? LikesCount { get; set; } public virtual Int64? Created { get; set; } public virtual Int64? Edited { get; set; } public virtual string UsersId { get; set; } //public virtual int UsersId { get; set; } public Groups Groups { get; set; } public ApplicationUsers Users { get; set; } public ICollection<Votes> Votes { get; set; } } public class Votes { public virtual int Id { get; set; } public virtual int NodesId { get; set; } public Nodes Nodes { get; set; } public virtual int CommentId { get; set; } public Comment Comment { get; set; } public virtual string UsersId { get; set; } public ApplicationUsers Users { get; set; } } public class ApplicationUsers : IdentityUser { public virtual string Email { get; set; } public int FriendId { get; set; } public ICollection<Nodes> Nodes { get; set; } public ICollection<Groups> Groups { get; set;} public ICollection<GroupsMember> GroupsMember { get; set; } public ICollection<Comment> Comments { get; set; } public ICollection<Votes> Votes { get; set; } public ICollection<Profiles> Profiles { get; set; } }
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder) { modelBuilder.Entity<Votes>() .HasRequired(n => n.Nodes) .WithMany() .HasForeignKey(i => i.NodesId) .WillCascadeOnDelete(false); modelBuilder.Entity<Votes>() .HasRequired(n => n.Comment) .WithMany() .HasForeignKey(i => i.CommentId) .WillCascadeOnDelete(false); modelBuilder.Entity<Votes>() .HasRequired(n => n.Users) .WithMany() .HasForeignKey(i => i.UsersId) .WillCascadeOnDelete(false); base.OnModelCreating(modelBuilder); }
"ExceptionMessage":"Introducing FOREIGN KEY constraint 'FK_dbo.Votes_dbo.Nodes_NodesId' on table 'Votes' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.\r\nCould not create constraint
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)