Containerized application is now commonly used in cloud or on-premise platforms. This article shows you how to overwrite an ASP.NET Core connection string configuration in appsettings.json via environment variables in Docker Linux containers. The same approach can be applied to any other type of configuration property.
Scenario
Assuming the following is the default appsettings.json in your ASP.NET Core web application.
{
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Database=kontext;User id=sa;Password=password;MultipleActiveResultSets=true;"
}
}
To overwrite this default connection string, we need to use environment variable syntax "SectionName__PropertyName". For this case, the environment variable should be ConnectionStrings__DefaultConnection.
This approach can be applied to overwrite all other settings in appsettings.json file.
Run docker
We can pass in environment variable to overwrite the default configuration:
docker run -e ConnectionStrings__DefaultConnection="Server=host,1433;D...;"
Use .env file
To use .env file in docker or docker compose command, simply add the following into the file:
ConnectionStrings__DefaultConnection=Server=host,1433;D...;
OtherSection__Property=Overwrite property...