I'm using TFS Service for automatic deployment to Windows azure. The project is a Web Role and some class libraries. The deployment tasks works great - the only question is where to store the connectionstring? Normally I would store it in csdef / cscfg to use the correct value in development and in cloud environment but if I use SimpleMembership I tseems if this is not an option because I have to provide the Web.Config value during initialization.
Does anyone has a "best practice" for this problem?
Thank you!