-
-
Notifications
You must be signed in to change notification settings - Fork 298
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 ER diagram of your database. Requires the Mermaid editor extension
Right click a database connection in Server Explorer and select a tool:
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.