9

How do i create a database diagram in MS Visual Studio 2015? There is no option to create one.

Guilherme Fidelis
  • 1,022
  • 11
  • 20
Muneeb Rehman
  • 135
  • 2
  • 10
  • Did you manage to find a solution? trying to find something, but currently without any luck. – Crooker Aug 07 '16 at 16:42
  • Possible duplicate of [Visual Studio 2015 - Sql Server Project Database Diagram](http://stackoverflow.com/questions/36655408/visual-studio-2015-sql-server-project-database-diagram) – Guilherme Fidelis Sep 29 '16 at 11:49

1 Answers1

1

Add to project ADO.NET Entity Data model. which create .edmx file and contains a tables with relation. More info MSDN.

  1. https://msdn.microsoft.com/en-us/library/ms189078.aspx

  2. https://msdn.microsoft.com/en-us/library/ms171978.aspx

It also install Entity framework.

Open Server explorer > Connection to Database. Select Microsoft SQL Server(you must be installed it first ), Server name=.; (or your PC name) and then choose your database schema.

If this is complicated to you,please watch this video :) Good luck

Visual Studio tutorial: Working with databases in Server

Sachith Wickramaarachchi
  • 5,546
  • 6
  • 39
  • 68