Managing ASP.NET Dev, Staging and Production Connection Strings

If you work with a large number of applications then you know what a pain it can be to manage multiple web.config files and multiple connection strings for development, staging/test, and production databases. This article discusses an alternative that allows connection strings to be consolidated into a single file that can be shared across mutliple applications. It also shows how connection strings can be loaded dynamically based upon a URL which can greatly simplify getting correct connection strings for dev, staging, and production databases.