Entity Diagram for Visual Studio

True entity relationship diagramming for SQL Database projects. Directly in Visual Studio!

Overview

Entity Diagram for Visual Studio allows database developers to create Entity Relationship (ER) diagrams directly from the SQL code in the SQL Database project. In addition, the ER diagram stays in sync with all changes made to the table eliminating the need to maintain both the code and the diagram.

Visual Studio Integration

Built as a modern Visual Studio Extension to take full advantge of the Integrated Development Environment.

Fully Synchronized to Project

Changes made to table columns, indexes and relationships are sychonized with a single click!

Schema and Diagram Together

Save time by maintaining all your schema objects and entity diagrams at the same time.

Multiple Lanaguages

Currently available in English, Spanish and French.

More languages to come.

Entity Diagram for Visual Studio can be downloaded from the
Visual Studio Marketplace

Features

Entity Diagram for Visual Studio is built to allow database developers to quickly create ER diagrams and keep those diagrams in sync with the database project code as it changes over time.

  1. Create a new diagram by choosing Project/Add New Item. Projects can support multiple diagrams for different areas of the database.
  2. Add a new table to both the diagram and the project leveraging the New Table Wizard. The wizard will allow the creation of common fields used in many tables.
  3. Jump from the model to edit any table using Visual Studio's built-in table editor. Then quickly refresh the model with a simple right-click in the model.
  4. Edit foreign key names and properly show the cardinality in the diagram.
  5. Quickly arrange the tables in the model using hierarchical or radial patterns.
  6. Export the model for sharing and printing to a variety of formats including jpg, png, xps and pdf.
  7. Version control models in sync with database changes by checking in updates when the rest of the database changes are checked in.

These items are still a work in progress:

  • Entity Menu and Add Entity Diagram context menu are not localized.
  • Copying and pasting tables in a diagram.
  • How do I add a diagram to my SQL database project?

    To add a new entity diagram to the project, open the Add New Item dialog, select the Entity Relationship Diagram item, provide a name and click Add.

  • How do I add existing project tables to the diagram?

    Multiple tables can be added to the diagram by either right-clicking on the diagram and then clicking Select Table(s) for Diagram or from the Tools menu, click Entity Diagram/Select Table(s) for Diagram. This will open the Add Tables to Diagram dialog listing all tables found in the project. Check the tables to be added and click OK. The selected tables, along with any associated relationships, will then be added to the diagram.

  • How do I edit a table from the diagram?

    Right-click the table you want to edit and then click Edit Table.This will open the table in the Visual Studio table editor. Once the changes are complete and saved, right-click the table in the diagram and then click Refresh Table from File.

  • How do I add a new table to the diagram?

    Entity Diagram for Visual Studio includes a New Table wizard that facilitates the creation of new tables including some of the most common columns to be added in the table. To add a new table, right-click the diagram and then click Create New Table. In the Create New Table dialog, select a schema, provide a new name for the table and then provide a file name. Once these are complete, you can check the options for various columns to be included. After selecting all the desired options, click Save to add the new table to both the project and the diagram. To Edit the table further, right-click the table and then click Edit Table.

  • How do I refresh one or more tables in the diagram?

    Each table can be refreshed by right-clicking the desired table and then clicking Refresh Table from File. If there are multiple tables to be refreshed, from the Tools menu, you can click Entity Diagram/Refresh Diagram.

  • How do I delete a table from the diagram?

    A table can removed from the diagram by right-clicking the desired table and then clicking Delete Table. You will be asked if you also wish to delete the table from the project it self as well.

  • Can I rename a table in the diagram?

    Entity Diagram for Visual Studio does allow tables to be renamed directly in the diagram. However, it is highly recommended to use the SQL Refactor tool capability to rename objects in the project. This will ensure all references are properly renamed and the project is consistent. Once the rename is complete, the diagram can be refreshed and the path to the new table can be updated. If there is no risk of the project becoming inconsistent, you can proceed with renaming the table directly in the diagram.

  • Can I copy and paste a table in the diagram?

    Copying and pasting a table directly in the diagram is currently not supported. This csn be done in the project and then adding the new table to the diagram through the Select Table(s) for Diagram option of the context menu or from the Tools menu by clicking Entity Diagram/Select Table(s) for Diagram.

  • How do I print a diagram?

    Printing a diagram directly from Visual Studio is currently not supported. However a diagram can be exported to a variety of formats that can then be either shared electronically or printed in that format. To export a diagram, from the Tools menu, click Entity Diagram/Refresh Diagram. Select the desired format for the export and then click Save.

  • Can I view the SQL of a table in the diagram?

    You can view the SQL for a specific table be right-click the table and then clicking View SQL. This opens a dialog with the generated SQL that is used when saving changes made to the table directly in the diagram. SQL changes are saved to the file by Entity Diagram for Visual Studio when a new table is added from the diagram and when the Extended Properties wizard is used to add extended properties to table objects (columns, indexes, keys). The SQL generator can be modified how the SQL should look through the Entity Diagram options. These can be found going to the Tools menu, clicking Options, selecting the Entity Diagram section and then SQL Generation. Options include capitalizing keywords, data types and quoting (including brackets around names).

  • How do I manage Extended Properties?

    Extended propertied for SQL objects allows for developers to included documentation on the various database objects being created. While these can be very helpful in documenting the database, they are infrequently used due the effort in adding them to objects. Entity Diagram for Visual Studio includes a simplifieed interface for adding extended properties and allows for the generation of the necessary SQL to include these when deploying the database.
    You can add extended properties to a table by right-clicking on the specific table and then clicking Edit Extended Properties. The resulting dialog shows all of the objects on hich extended properties can be added. To add an extended property, select the specifc object (table, column, index, etc.), select the name of the extended property and add the property itself. Note that multiple properties can be added to each object. The default list of extended properties includes, Description, Logical Name and Sample Value. These can be modified/added to through the Entity Diagram options. These can be found going to the Tools menu, clicking Options, selecting the Entity Diagram section and then SQL Generation. Use the Extendedd Property Names area to include the specifc property names desired.

  • How do I register Entity Diagram for Visual Studio?

    Once you have purchased a license for Entity Diagram for Visual Studio (see below) and received the license via email, you will go to the Entity Diagram options. These can be found going to the Tools menu, clicking Options, selecting the Entity Diagram section. Click the Register button, paste the license key into the dialog, and then click OK. Entity Diagram for Visual Studio will validate the license initially against the server, activate it and then the software is registered.
    If there is a need to move a license to a new machine, use the Remove License button in the Entity Diagram options to clear the license from the current machine, repeat the steps above and the software will be properly registered on the new machine.

Pricing

Entity Diagram for Visual Studio is available for individual developers as well as in packs of 5 or 10 licences.

Individual Developer

$279



10 Developer License Pack

$2,499




Contact Us

  • support@shakesolutions.biz