As the title suggests, I am using a different database during development. It's easy enough to ensure that I am using the development database during development because I can do a simple debug.assert to ensure I am using the correct connection string.
However, I can't quite think how I would ensure that when the site is being published, or on the server, that a check is made to ensure the production version is using the production database.
Can anyone provide info on that?
Depending on your build configuration, different transforms are applied when you publish your site. I do use this for everything BUT connection strings, since in my case I use source control and I do not want production passwords checked in for all to see inside of source control.
Another option is to take advantage of configuration inheritance and define your connection string above the site level in machine level web.config (%windir%\Microsoft.Net\Fr