This post discuss about using Web.Config Transformations in Visual Studio 2010. It is a new feature in Visual Studio 2010.
You have a very simple web.config file as shown below. In this Config file we have a very simple connection string for NorthwindDatabase. It is pointing to the local SQL Server Express instance.