Reading ConnectionStrings in local.settings.json using GetEnvironmentVariable in Azure

Question

In Azure function v1, am trying to read the connection string present in local.settings.json using GetEnvironmentVariable static method

Here is my local.settings.json file

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true",
    "AzureWebJobsDashboard": "UseDevelopmentStorage=true"
  },
  "ConnectionStrings": {
    "OnPremisesConnection": "Server=test;Initial Catalog=testdb;Integrated Security=SSPI;"
  }
}

using the following code am reading the connection string

string variableName = "OnPremisesConnection";
var res = Environment.GetEnvironmentVariable($"ConnectionStrings:{variableName}")

but am getting NULL as result. What am I missing here ?

Is there a specific reason why you aren't using the ConfigurationManager.ConnectionStrings[variableName] option? I'm not sure if Environment variables should/will work locally. — Jan_V
– Jan_V, Commented Aug 10, 2018 at 12:54
@Jan_V - It is only supported in v1, am advised to use GetEnvironmentVariable for better support in future — Pரதீப்
– Pரதீப், Commented Aug 10, 2018 at 12:55
@Pரதீப் Big sorry that I made a mistake, if you are still in v1, GetEnvironmentVariable can't get ConnectStrings as they are not imported into environment, only Values are available. I will update my answer in your last question. — Jerry Liu
– Jerry Liu, Commented Aug 10, 2018 at 13:40
@JerryLiu Can you please provide your answer to this post as well or link to the 'last question' that you are referring to, in your comment. This would help other readers. Thanks. — Karishma Tiwari - MSFT
– Karishma Tiwari - MSFT, Commented Aug 10, 2018 at 21:12

Andrew Yanchak · Accepted Answer · 2020-07-14 10:47:29Z

0

Ok. You can try the next:

var config = new ConfigurationBuilder()
            .AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
            .AddEnvironmentVariables()
            .Build();
 
 string connectionStr = config["ConnectionStrings:OnPremisesConnection"]

answered Jul 14, 2020 at 10:47

Andrew Yanchak

452 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Reading ConnectionStrings in local.settings.json using GetEnvironmentVariable in Azure

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related