Edit Question - KnowledgeHub

Title Body

I am starting out with using the EF Code First with MVC and am a bit stumped with something. I have the following db structure (Sorry but I was not allowed to post an image unfortunately): Table - Products Table - RelatedProducts 1-Many on Products.ProductID -> RelatedProducts.ProductID 1-Many on Products.ProductID -> RelatedProducts.RelatedProductID Basically I have a product that can have a series of products that are related to it. These are kept in the RelatedProducts table with the relationship defined by the ProductID and the ProductID of the related product which I have named RelatedProductID. In my code I has produced the following classes: public class MyDBEntities : DbContext { public DbSet<Product> Products { get; set; } public DbSet<RelatedProduct> RelatedProducts { get; set; } } public class Product { public Guid ProductID { get; set; } public string Name { get; set; } public string Heading { get; set; } public string Description { get; set; } public decimal Price { get; set; } public Guid CategoryID { get; set; } public string ImageURL { get; set; } public string LargeImageURL { get; set; } public string Serves { get; set; } public virtual List<RelatedProduct> RelatedProducts { get; set; } } public class RelatedProduct { public Guid ProductID { get; set; } public Guid RelatedProductID { get; set; } public virtual Product Product { get; set; } public virtual Product SimilarProduct { get; set; } } I then try to access these in code using: myDB.Products.Include("RelatedProducts").Where(x => x.ProductID == productID).FirstOrDefault(); But I keep getting the following error: {"Invalid column name 'ProductProductID2'.\r\nInvalid column name 'ProductProductID2'.\r\nInvalid column

Tags (comma-separated) Cancel