It took some imagination and perseverance but I figured out how to use Web.config Transformation Syntax for Web Application Project Deployment to get the connection string to be transformed during a Web Deploy.