-
-
Notifications
You must be signed in to change notification settings - Fork 300
Database tools
The database tools are a set of tools to enhance your development experience with databases in Visual Studio.
Right click a project in Solution Explorer and select a tool:
This feature allows you to generate a .cmd file to run the Data API Builder dab CLI tool to quickly configure a CRUD Web API with REST and GraphQL endpoints. Read more in my blog post
Allows you to visualize the schema of the chosen database. Requires the Visual Studio DGML viewer component (not available for ARM64)
Generate a Mermaid Entity Relationship diagram of your database project. Requires the Mermaid editor extension in order to view the diagram in Visual Studio.
Right click a database connection in Server Explorer and select a tool:
Generate a Mermaid Entity Relationship diagram of your database project. Requires the Mermaid editor extension in order to view the diagram in Visual Studio.
Runs T-SQL static code analysis against your SQL Server / Azure SQL database, and displays the results in html format. If you want to add this to a database project during build, follow the guide in my blog post. Thanks to the SqlServer.Rules project for sharing the building blocks for this feature.