The default of ConfigurationBuilder is looking for appsettings.<EnvironmentName>.json
file, so based on the environment that you are working with
when you are in IIS Express you are in Development and when you deploy your application your environment is Production. This is why you need appsettings.Production.json
CLICK HERE to find out more related problems solutions.