views:

50

answers:

0

I have the User table with id userId. Then I have KnowUser table which contains data which user know some other user. This table have two foregin keys on User table as a combined primary key.

So:

User
Id PRIMARY KEY
Name

KnowUser
UserId FK on User
UserKnowId FK User
Years
PRIMARY KEY(UserId, UserKnow)

When do I import those tables into EDMX I get the following error:

Error 1 Error 3021: Problem in Mapping Fragment starting at line xxx: Each of the following columns in table user_know is mapped to multiple conceptual side properties: user_know.userKnowId is mapped to '<'user_know_ibfk_2.user_know.userKnowId, user_know_ibfk_2.User.Id'>'

Question is does EF support combined key from the same table?