Now that the SQL Server Database has been set up, we need to tell our application to use it instead of localDb while in production. We can easily do that by leveraging the ASP.NET Core default pattern for configuring application behavior across multiple environments.
To implement it within our project, we need to perform the following steps:
- Copy the existing connection string from the appsettings.json file to the appsettings.Development.json file so that we'll still be able to connect to the localDb instance when we run the project in debug/development mode. Then, replace the appsettings.json connection string with a new one, pointing to the new SQL Server instance so that the web app will connect there ...
