How to publish ASP.NET website with alternative configuration settings
<p>I am working on a web project as a Web Site, rather than a Web Application. How can I use a different config file depending on where it is hosted from, so the local version uses my local SQL install, but the published version uses the live database? e.g. connectionStrings.config ignored (not published), connectionStrings.live.config published as connectionStrings.config</p>

<p>I see a policy file option, would that be something able to do this?</p>
