How to add web.config file in Azure?

In the new project templates, web.config file has been updated to use project.json file. That file is already available in your current directory. As you mentioned you need to use the connection string, you can access your connection strings from the Azure portal for SQL databases. You do not need a web.config file to access the strings in order to process the databases.

As for your code (that is visible in the image), I would recommend instead of getting the connection string from there (because web.config isn't there), why don't you hard code that? Hardcoding that in the code would keep the connection string available and since your virtual machines, SQL databases, and functions are all under the same subscription, you can target your SQL Servers locally using their internal IP addresses.

Read this article to learn more on this, https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-dotnet-simple/. It shows you how to connect, you can use the same method and call the connection. For an overview of connection strings, please read, https://msdn.microsoft.com/library/ms254494.aspx

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Afzaal Ahmad Zeeshan10y ago
In the new project templates, web.config file has been updated to use project.json file. That file is already available in your current directory. As you mentioned you need to use the connection string, you can access your connection strings from the Azure portal for SQL databases. You do not need a web.config file to access the strings in order to process the databases.
As for your code (that is visible in the image), I would recommend instead of getting the connection string from there (because web.config isn't there), why don't you hard code that? Hardcoding that in the code would keep the connection string available and since your virtual machines, SQL databases, and functions are all under the same subscription, you can target your SQL Servers locally using their internal IP addresses.
Read this article to learn more on this, https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-dotnet-simple/. It shows you how to connect, you can use the same method and call the connection. For an overview of connection strings, please read, https://msdn.microsoft.com/library/ms254494.aspx
0