i am defining some of my models atm using EF5 Code First. I have these three sample classes with a many-to-many relationship:
public class Team { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Team_Id { get; set; } [MaxLength(150)] public string TeamName { get; set; } public virtual ICollection<User> Users { get; set; } [public virtual ICollection<Role> Roles { get; set; } // 1 [Timestamp] public byte[] TimeStamp { get; set; } } public class User { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int User_Id { get; set; } [MaxLength(150)] public string LoginName { get; set; } [MaxLength(150)] public string Nachname { get; set; } [MaxLength(150)] public string Vorname { get; set; } public virtual ICollection<Team> Teams { get; set; } public virtual ICollection<Role> Roles { get; set; } // 2 [Timestamp] public byte[] TimeStamp { get; set; } } public class Role { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Role_Id { get; set; } [MaxLength(50)] public string RoleName { get; set; } [Timestamp] public byte[] TimeStamp { get; set; } }
As you can see there is a many-to-many relationship between teams and users. I am trying to get this to work for hours. I always get an JS Exception with the error message "bad nav properties" in VS 2012. At first i thought it was the ICollections Teams/Users in Users/Teams-Class but it wasnt. The problem seems to be the two calls 1) and 2). I f i remove either one of them it works. Renaming one and keeping both fields active still throws the error. Maybe anyone has an idea what is going on.
Many thanks
This question was posted by SirSmackalot on our IdeaBlade forums. I am reposting the question and answer here since I think it will be useful to the Breeze Stack Overflow community.