Creating Composite primary keys in a many-to-many relationship in Entity Framework

I have two tables th开发者_Go百科at are connected via a join table in a many-to-many relationship in the Entity Framework. I need to add a composite primary key in the join table for the two columns that are related to the joined tables via standard foreign keys but I'm sure how to do that.

If your join table has a composite key on both foreign keys, the Entity Framework designer in VS2008/2010 should pick up on that.

SQL:

CREATE TABLE MyTable
(
  ColumnFK1  int,
  ColumnFK2  int

PRIMARY KEY (ColumnFK1, ColumnFK2)
)

If the table is already created you can modify the primary key in Management Studio.