1

I have these relations in my data base: enter image description here

I need all authors related to my book stored in book entity class? I was trying to resolve this by using entityset but I can't use it because there is no primary key in BookAuthors table!

Any kind of help will be great! =)

Jackson Pope
  • 14,520
  • 6
  • 56
  • 80
Powerslave
  • 321
  • 1
  • 2
  • 9

1 Answers1

0

LINQ-to-SQL requires a primary key in order for it to materialize entities. And since neither Books nor Authors entities know anything about each other, I think your only option is to add a PK to BookAuthors as Pleun mentioned.

This question is very similar to yours, but note the PK on the Order_Detail table: Problem with Linq2Sql Many-to-Many relationship & Inserting new objects.

Community
  • 1
  • 1
Yuck
  • 49,664
  • 13
  • 105
  • 135