Prerequisites
This video would be useful for anyone with general knowledge of Visual Studio web projects and database connection strings. Knowledge of Windows Azure is useful but not necessary.
Summary
Covers how to deploy a Windows Visual Studio project to Azure specifically in transforming a database connection string for deployment. note: In the video I demonstrate how to do an automated ConnectionString transformation on deployment (Publish) and how to configure Azure to use a specific connection string based on the name. These both work – but I have tested this and it will work fine if you only do the Azure configuration.
Video
Reference Materials
Correct Code for Retrieving a ConnectionString
Using System.Configuration;
string conn = ConfigurationManager.ConnectionStrings["Name_Of_string"].ConnectionString;