EF Association, Extra Column

Question

I'm trying to set up my EF Model. I have 2 tables: Posts and Comments. I right clicked and added an association and I see a new column was generated "PostPostID". Is this necessary? Can I delete it? When I do, I get this error: There is no property with name 'PostsPostID' defined in type referred by Role 'Comments'.
enter image description here
Thank you.

I unchecked "Add foreign key properties..". That did it. Knew it was something simple. — Rivka, Mar 21 '12 at 00:35

score 1 · Accepted Answer · edited May 23 '17 at 10:32

1

That column was added as Foreign Key to your association but you probably already have foreign key as part of the entity - PostID. You will need to map PostID as FK for the new association.

edited May 23 '17 at 10:32

Community

1
1

answered Mar 21 '12 at 08:54

Ladislav Mrnka

360,892
59
660
670

EF Association, Extra Column

1 Answers1