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?