Tip: Automating Dev, QA, Staging, and Production Web.Config Settings

"One of the questions I get asked fairly regularly is: 'how can I can easily change different configuration settings in my web.config file based on whether my application is in a dev, qa, staging or production mode?' The most common scenario for this is one where an application uses different database connection-strings for testing and production purposes."