-
Book Overview & Buying
-
Table Of Contents
Clean Architecture with .NET
By :
Visual Studio simplifies the process of interacting with SQL databases via SQL Server Object Explorer. This tool is essential for those looking to manage their database directly within the IDE. Should SQL Server Object Explorer not be immediately visible in your Visual Studio workspace, it can be easily accessed from the View menu located at the top of the interface. With the explorer open, the next step is to initiate the addition of a new SQL Server connection.

Figure 7.1 – A screenshot showing how to add a new SQL server to Visual Studio's SQL Server Object Explorer
You'll be prompted for the connection information, where you will select SQL Server Authentication as the authentication method, add the server name, username, and password, and finally, you'll be able to click Connect to add the SQL server.

Figure 7.2 – A screenshot showing the connection settings for the SQL server in Visual Studio
This direct...