I am using VS2010, and I understand that when I publish a web application, the Web.config I am using is transformed based on the build settings.
i.e. When I choose Debug, it uses my development SQL server, and when I choose Release, it uses my production SQL server.
What I want to know is: Can I, using only the built in Visual Studio Development Server, select "Release" from the Configuration drop-down, and then the green "Continue" arrow (F5), and run using the transformed Web.config settings?
I would be quite happy having another file such as "generic.config" (or better: "Web.Generic.config"), which holds the master code if necessary.