Adding foreign key in visual studio 2012

Question

I'm developing my first MVC project in Visual Studio 2012. Because i prefer "database first" approach i've started to design database. The question is: Why when i want to add foreign key i have all key properties disabled to edit (left):

enter image description here

I can only modify script directly (right) but is this really only solution? Or i did something wrong?

Thanks for any help.

Did you ever solve this issue? I also cannot edit foreign keys through the properties panel. — Kris Harper, Apr 08 '13 at 13:34

score 1 · Answer 1 · edited Jul 26 '17 at 08:09

1

All you need to to do is right click on the foreign key options on the right side of the table view and select add new foreign key. Then in T-SQL window you need to manually edit the the foreign key and foreign key table.

edited Jul 26 '17 at 08:09

Brian Hooper

21,544
24
88
139

answered Apr 12 '14 at 13:48

Atul Chaudhary

1,113
1
15
15

score 0 · Answer 2 · answered Jun 28 '13 at 08:33

0

Perhaps you need to manually add the relationship? It'll allow you to change it however you like there.

answered Jun 28 '13 at 08:33

LTKD

214
2
13

Adding foreign key in visual studio 2012

2 Answers2