3

I am using appsettings.json in .Net core project for connection string. My connection string is :

  "ConnectionStrings": {
    "OT_DB_Connection": "Data Source=108.***.**.**;Initial Catalog=O*******s;User ID=O*******s;Password=O*********$"
  },

In startup.cs i am accessing connection string with key like this 

   options.UseSqlServer(Configuration.GetConnectionString("OT_DB_Connection"));

I deployed this code on azure and i have sql database on azure. After deployment how my website will use the connection string of azure ? How to override the local connection string with azure connection string at run time.

Improve this question
1
  • 3
    It's not a good idea to create a new account to ask your question a second time. This can result in a ban. Commented Aug 28, 2018 at 9:11

1 Answer 1

Reset to default
3

You should read the following article:

Multiple Environment Configuration Files in ASP.NET Core

You can have multiple appSettings e.g. 1 for you local environment and 1 for Azure etc. When you publish your app to Azure, you can add an application setting called ASPNETCORE_ENVIRONMENT and add a value that maps to your environment for your app to pick up the correct configuration. If you have an appSettings.Azure.json file you can set ASPNETCORE_ENVIRONMENT to Azure and it will use that configuration file.

If you do not want to take this approach, you can also override the connection string directly in Azure as show in the picture below. This is accessible under your app service -> Application Settings -> Connection Strings. You will want to override OT_DB_Connection.

enter image description here

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

7 Comments

Thanks for the quick response but how connection string is overrided automatically ?
Sorry, it's not clear what you're asking. Please note, that once you've overridden the connection string in Azure as mentioned above, you will not need to do it again.
I am asking about the second approach you mentioned ' you can also override the connection string directly in Azure as show in the picture below '.How this technique works ? If you can Please elaborate that would be a great help.
I've explained it in my answer. Go to your app service in Azure -> Application Settings -> Connection Strings. Add a key called "OT_DB_Connection" and then add a value that corresponds to the connection string you want to use in Azure. The picture shows everything.
That means there is no change required in code for this ?
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.