How to remove a ConnectionString using Config Transformations

Question

I have a Web.config with several ConnectionStrings

<connectionStrings>     <add name="connStr1" connectionString="...     <add name="ConnStr2" connectionString="...     <add name="connStr3" connectionString="... 

Is there a way using config transformations to remove a specific connectionstring? Something Like:

<connectionStrings>     <xdt:Remove connStr2? 

Obviously no where near the correct syntax, but you get my drift...

Answer 1

This will remove a specific connection string based on its name.

<configuration>   <connectionStrings>      <add name="ConnStr2" xdt:Transform="Remove" xdt:Locator="Match(name)" connectionString=" " />    </connectionStrings>  </configuration> 

Note that the connectionString value is not empty string, but is instead a space. Any non-empty value would do.