Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Generating entity relationship diagram in Visual Studio 2015

Tags:

sql

database

visual-studio

entity-relationship

visual-studio-2015

Can you tell me how I can generate an ER diagram for my database1 (see below) created with VS 2015

enter image description here

Thanks in advance

like image 571
xAminex Avatar asked Apr 10 '16 15:04

xAminex

People also ask

Can you create an ERD in Visual Studio?

After installation, ER models can be created in . erd files. Use the New Sample ER Model command in the Command Palette or refer to the example below to get started with a basic model.

Can we generate ER diagram from database?

You can also import your own database to streamline ERD creation. LucidChart has plenty of collaboration options so you can work on the diagram with your teammates collectively (with features like sticky notes, comments, and mentions).

1 Answers

Ensure you installed either Microsoft SQL Server Data Tools or Microsoft Web Developer Tools in order to get the Entity Data Model Designer.

These are the steps to generate entity relationship diagram. It was tested in VS2012

  1. Open Visual Studio
  2. Create a project or open an existing project (must be Visual Basic, Visual C# project, or Console Application)
  3. Right-click the project and choose Add -> New Item…
  4. Under Visual C# Items select “Data”
  5. Select the template “ADO.NET Entity Data Model”
  6. Give it a name and click “Add”
  7. Select “Generate from database” or “Empty model”
  8. If “Generate from database” selected enter connection info, choose the database objects and done!

The model is stored as a “.edmx” file.

like image 178
user3402754 Avatar answered Oct 05 '22 09:10

user3402754
Sign in to Comment

Related questions

MySQL - Selecting rows with null columns
SQL: 3 tables (book, author, book_author)
Sort string as number in sql server
SQL where Date from today minus and plus days
Call one CTE in another CTE
Oracle 11g: LISTAGG ignores NULL values
SQL Server concatenation varchar and int
SQL Error: 1191 - Can't find FULLTEXT index matching the column list
Where statement with multiple 'Not Like'
Symfony/Doctrine: SUM and AVG score of players
Oracle: remove first 4 characters from a string
SQL Server Management Studio can not connect
Renamed a table to sp_help and cannot rename it back
Why can't I specify both a Primary Key and a Unique Constraint on the same table?
Columnstore index proper usage
How Stuff Works Or Logic of Stuff & XML Path in SQL
Using sqlalchemy to query using multiple column where in clause
How to insert multiple rows in the same table-Oracle 10g
Create or alter trigger if exists
How to rollback new records if a later record fails to add in Laravel 5?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!