Code First Entity Model.. Joined Table without Primary Key

Question

im using Code First Entity Model with Web API Asp.Net
i need 3 tables in total
The First table(Table1) contains some information with a unique Id lets say it is like

string id 
string model

The second Table (Table2)contains some information about the user. lets say it is

string Id
string name
string company

now i need a third table. which would only work as a joining table and would contain

Table1 ModelInfo
Table2 UserInfo

but it is showing me an error that table cannot be created with out a unique id. but as my architecture is i dont need a unique id
what should i do? or do i need to change my architecture?

score 1 · Accepted Answer · edited May 23 '17 at 12:16

1

Your question is general EF CodeFirst Many-to-Many relationship. Suggested readings:

edited May 23 '17 at 12:16

Community

1
1

answered Jul 23 '12 at 22:10

astaykov

30,768
3
70
86

Code First Entity Model.. Joined Table without Primary Key

1 Answers1