Reading connection string from Azure website connection strings configuration

Question

I have uploaded a azure webjob in a azure web site. I was trying to read a connection string from the azure website where the azure webjob is using below code but it is not returning anything. The connection strings in the azure websites are located in the configure tab of the azure website. Am I doing something wrong here.

CloudConfigurationManager.GetSetting("ConnString")

Thanks

AlexC · Accepted Answer · 2014-10-31 14:03:16Z

7

The CloudConfigurationManager.GetSetting("ConnString") is looking for a setting with the key "ConnString" in your App Settings within Azure rather than your Connection Strings.

You need to add a value in the App Settings for your Web Site which contains your connection strings

enter image description here

edited Oct 31, 2014 at 14:03

answered Oct 31, 2014 at 13:57

AlexC

10.8k4 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user505210 Over a year ago

I changed it to ConfigurationManager.ConnectionString["ConnString"] and this got me the value also. Thanks for the quick answer .

samneric Over a year ago

User505210 - You should post that as an answer and I'd upvote it :)

Amit Apple · Accepted Answer · 2014-10-31 18:07:19Z

0

To get app settings or connection string use the regular .NET API

System.Configuration.ConfigurationManager.AppSettings["name"] and System.Configuration.ConfigurationManager.ConnectionStrings["name"]

CloudConfigurationManager is for web roles/worker roles.

answered Oct 31, 2014 at 18:07

Amit Apple

9,1921 gold badge47 silver badges51 bronze badges

4 Comments

Erik Oppedijk Over a year ago

The CloudConfigurationManager.GetSetting is used as an abstraction, running on azure it will get the azure app settings, running local will access the web.config

Amit Apple Over a year ago

When you're using Azure Websites PAAS solution there is no need for redundant abstractions as you just get the proper behavior from the get go that works both locally, on IIS server and in Azure. also you don't need to reference an extra assembly and there is no connection string support for CloudConfigurationManger.

Sajad Deyargaroo Over a year ago

Absolutely, ConfigurationManager.AppSettings works with both web.config and azure settings, there is no need to use CloudConfigurationManager.GetSetting.

arneeiri Over a year ago

If you deploy using Azure Resource Manager Templates you don't know the connection strings in advance. There it is super useful to have access to the configured connection strings in the webjob.

Collectives™ on Stack Overflow

Reading connection string from Azure website connection strings configuration

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related