Web.config Remove ConnectionStrings node from Web.Release.Config

Question

I have this in my Web.config so that my service will run locally:

  <connectionStrings>

    <add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=IPADD;Initial Catalog=DB;Persist Security Info=True;User ID=UN;Password=PW" />
  </connectionStrings>

I need this here because the Web.Debug.Config doesn't work. So when I publish I want to remove this string because it is actually inherited from a parent Web.config

  <connectionStrings>
    <remove name="DefaultConnection"/>

  </connectionStrings>

This doesn't seem to work... (it throws a The entry 'DefaultConnection' has already been added. error)

How can I remove it? XSLT?

P.s. I can't use clear/ because it removes the Machine.Config DB Connection string to the Membership provider also throwing a different error

Piotr Stapp · Accepted Answer · 2013-04-09 17:38:44Z

6

Put below code:

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

But be careful when you do publish from visual studio. When you look on Output view. It should write you something like:

Transformed Web.config using Web.Release.config into obj\Debug\TransformWebConfig\transformed\Web.config.
Copying all files to temporary location below for package/publish:

But if you have active "Debug" you will have Web.Debug.config instead of Web.Release.config

answered Apr 9, 2013 at 17:38

Piotr Stapp

19.9k11 gold badges72 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Web.config Remove ConnectionStrings node from Web.Release.Config

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related