An excellent walkthrough on how to get connectionstrings integrated into Azure roles

Excellent walkthrough - here

http://romikoderbynew.wordpress.com/2011/02/02/using-autofac-mvc3-sqlmembershipprovider-and-entity-framework-in-windows-azure-and-sql-azure/