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.
New Table Wizard
Quickly create tables with properly named identifying columns, name columns, created and modified columns as well as timestamp and unique identifier columns. Tables are added to both the diagram and the database project.
Foreign Key Editor
Foreign keys are read from the table definition sql files and then represented in the diagram as identifying or non-identifying relationships. Cardinality, as well as Delete and Update Actions can be edited quickly through the foreign key editor.
Extended Property Editor
Extended properties can help to fully document the database objects and provide fuller context to users and to developers. However, managing extended properties in SQL Server is a difficult undertaking without a simpler interface for them. The Extended Property Editor allows for the adding, editing and deleting of extended properties on tables, columns, indexes, constraints and triggers.
Three default properties are initially available: Description, Logical Name and Value. Additional ones can be added through the extension options (Tools/Options/Entity Diagram/SQL)
Entity Diagram for Visual Studio supports both VS 2019 and VS 2022. For the Visual Studio 2022 version, go to Entity Diagram for Visual Studio
The trial version allows for the creation of diagrams with a maximum of ten (10) tables. A purchased license removes this limit and allows for any number of tables. For additional details about Entity Diagram for Visual Studio and to purchase licenses, visit the Shake Solutions website.
Initial public release