Model first junction table using foreign keys as composite primary key?

Question

I have a Job table and a Contact table, I need to create another table JobContact to allow many to many, but I want the JobId and ContactId to be used as its primary key.

I need it on the designer so I can add additional columns to it.

Is there a simple way to do this?

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

1

In such case you must create new JobContact entity in the designer and mark JobId and ContactId as entity keys. After that you can add additional properties to this entity and create one-to-many relation with Job and Contact entities.

edited May 16 '12 at 23:37

Shimmy Weitzhandler

101,809
122
424
632

answered May 16 '12 at 08:43

Ladislav Mrnka

360,892
59
660
670

Model first junction table using foreign keys as composite primary key?

1 Answers1