Many to Many Quandry RRS feed

  • Question

  • Hello, 

    I'm trying to get my head around using many to many relationships with LINQ to Entities and whether it's the best option.

    In Short, I have a 'Quotes' table and an 'Items' table so many Quotes can have many Items. I've set this up and using a 'QuotesItems' table that just has  QuoteID' and 'ItemID' columns.

    I can derive the required information using SQL but throughout so far I have been using LINQ to Entities. I cannot add the link table to the edmx file as there is no Primary Key. Do I need to create a pointless Primary key column or is there a better way. I assume this is a common situation.

    Having done some reading, I notice some people say they don't use many to many relationships. How would this be possible?



    Wednesday, September 3, 2014 9:17 PM