---
title: "How to configure settings for visual studio?"  
description: "How to configure settings for visual studio?"  
author: "Nishi Tiwari"  
published: 2020-01-07  
updated: 2020-01-07  
canonical: https://www.mindstick.com/forum/155646/how-to-configure-settings-for-visual-studio  
category: "webhosting"  
tags: ["google cloud"]  
reading_time: 2 minutes  

---

# How to configure settings for visual studio?

[describe](https://www.mindstick.com/interview/12752/what-is-ddms-describe-some-of-its-capabilities) it.

## Replies

### Reply by Nishi Tiwari

## Configuring settings

- To open the sample app in Visual Studio, in the getting-started-dotnet\aspnet\2-structured-data directory, double-click 2-structured-data.sln.
- In the Solution Explorer pane, click Web.config.
- In Web.config, complete the following steps:

a. Set GoogleCloudSamples:ProjectId to your project ID.

b. Set GoogleCloudSamples:BookStore to sqlserver.

c. Near the bottom of the file, under <connectionStrings>, find the connectionStrings XML sub-element with the attribute name="LocalSqlServer". Update the connectionString value with the external IP address, database name, username, and password of your SQL Server instance. For example, the connectionString for a remote SQL Server on IP 104.155.20.171 with database = bookshelf, user = dotnetapp and password = test looks like this:

connectionString="Data Source=104.155.20.171;Initial Catalog=bookshelf;Integrated Security=False;User ID=dotnetapp;Password=test;MultipleActiveResultSets=True"

- Save and close Web.config.
- To build the solution, in the Visual Studio menu, click Build and then select Build Solution.
- To create the database tables, in the Visual Studio menu, go to Tools > Nuget Package Manager > Package Manager Console. At the PM > prompt, enter the following command:

Add-Migration Init

- Create the tables in the SQL Server database that are used to store the books' data for the Bookshelf app. In the Package Manager Console, enter the following command:

## Update-Database


---

Original Source: https://www.mindstick.com/forum/155646/how-to-configure-settings-for-visual-studio

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
