How to deploy ASP.Net core API with connectionstring to IIS?

Bubble Bub

6y5.4k.NET

I'm new to ASP.Net core. I try to develop a simply ASP.Net core MVC Web API. The API will connect the database host at cloud. I write the connection string in the appsetting.json and I try to deploy the API in my local IIS and run the API. It's work fine. When I try to move the connection string to Environment variable and deploy again, the Web API not work. The browser show me "The Page isn't working. HTTP error 500".

I have few question to ask

1. In real world, where should we store the connection string and deploy to server since the user name and password is sensitive.

2. What's wrong to my Web API, it wont work when the connection string is in Environment variable?

Thanks

2 Replies

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

Bubble Bub6y ago
Hi Sanwar,

If I add the connection string in appsettings.json, it will expose the sensitive data such as my password during I deploy my API into real world and when I upload my project to github. How I can prevent my connection string been expose?
Sanwar Ranwa6y ago
Hello Bubble

You can add connection in appsetting.json file only, It better to add in appsetting.json file

https://weblog.west-wind.com/posts/2016/jun/06/publishing-and-running-aspnet-core-applications-with-iis