Uninstall ConnectionString during deployment with Visual Studio 2012

Question

I am working on a project with two web applications, one of which is hosted as a long-running process (with the application), the other is a regular MVC application. They use the same data file, thus the same connectionString. The appfabric application is deployed as a child of main, using the inheritance of web.config (we do not want to duplicate the connection string in the web configuration)

My problem is that with the new Visual Studio 2012 wizard, a connectionString is automatically added to publish, even if I disable the "Use this connection string at runtime" line.

I am also trying to use the web config transform as follows:

<connectionStrings> <add xdt:Transform="RemoveAll" /> </connectionStrings> 

But the publishing line is still in my web configuration after publishing.

Any suggestions? I am thinking of removing completely web configurations for this child application, but this is not ideal.

Answer 1

The answer can be found here: Web Deployment / Publish adds an unknown connection string?

Add this project property to the .csproj file by editing the XML:

 <Project> <PropertyGroup> <AutoParameterizationWebConfigConnectionStrings>false</AutoParameterizationWebConfigConnectionStrings> ... </PropertyGroup> ... </Project>