I have an automated build process that sets up the application for a specified mode (e.g. Dev, uat, live). Depending on this mode I want to update Connection Strings to the relevant one.
However, in my Data Access Layer there is an app.config file which stores the connection string and this is used to feed the Settings.Settings file. In my builder I update the app.config's xml with the new Connection String and then the solution is built, however the Settings.setting file doesn't get regenerated with the updated app.config connection string and so the app doesn't connect to the correct DB.
Is it possible to do this or am I going about it the wrong way through a misunderstanding of how these config/settings files work?
Thanks Stuart