Open Database Schema in Visual Studio 2013

Question

I already spent a couple of hours on what I was trying to find myself, but so far no luck ...

I need to open a db table in a schema view so that I can add relationships for my tables.

This is what I have now:

This is how it was in the old visual studio:

this is what i need to get:

Thanks to everyone in advance!

Answer 1

Connect to the server through Server Explorer , then go to the table that will be used as a foreign key . Right-click and select Open Table Definition .

→ → , .

.

" "

. VS2013 SKU Pro Express ( ). Premium Ultimate . VS2012 Pro .

Answer 2

(*.mdf *.sdf) , . - . , . , , .

....

. , , ..

. , ..

Answer 3

(.edmx) db. , " " db,

1 -

2 - → →

3 - Select "ADO NET Entity Data Model"

4 - Select "EF Designer from Database"

5 And you have a chart!