You can't. The cscfg file is not visible to your web role project. But SQL Azure connection string and ASP.NET membership configurations are always stored in web.config. You can't store them in cscfg. So you don't need to duplex the settings.
My 'DataConnectionString' was setup @ the '.cscfg'
file, moving it to the web.config resolved the problem as U have mentioned, however, for sessions I an using Azure Blob tables by specifying a custom 'sessionState' provider, the custom provider attributes ARE SPECIFIED in the '.cscfg' file,
eg. <Setting name="allowInsecureRemoteEndpoints" value="true" />, since role is not loaded I have had to add these to the web.config as-well, and thus, I have added '/configuration/sessionState/providers/add/@allowInsecureRemoteEndpoints' attr,
this worked great, however, when I have added '/configuration/sessionState/providers/add/@mediaContainerName' website startup failed with 'Unrecognized
attribute: mediaContainerName', this, is specific to the mediaContainerName attr, are there any pre-defined set of attrs supported by the '/configuration/sessionState/providers/add' node of a custom sessionState provider ? why does my web site
fails to load ?
You say it is a Windows Azure application. But when you run it local, you select the website and you do debug->new instance to launch the website?
Why aren't you running the Windows Azure application in your local Windows Azure Compute Emulator?
In case of the first, the WebRole in the solution acts as a normal Website and does not have any understanding of the cscfg file whatsoever. In the second case, it is a local running Windows Azure application which is aware of the cscfg file.