.Net Web.Config Transformations, replace entire ConnectionString section

Question

I've been using web.config transforms with good success. I've just recently implemented connection strings encryption and am unsure how to modify my Release transform.

Before hand I was simply replacing the setting by using the locator for name.

Now that the settings are encrypted, there is no name.

<connectionStrings configProtectionProvider="Pkcs12Provider">
<EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element"
  xmlns="http://www.w3.org/2001/04/xmlenc#">
  <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#aes192-cbc" />
  <KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">
    <EncryptedKey xmlns="http://www.w3.org/2001/04/xmlenc#">
      <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#rsa-1_5" />
      <KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">
        <KeyName>rsaKey</KeyName>
      </KeyInfo>
      <CipherData>
        <CipherValue>CipherValueHere</CipherValue>
      </CipherData>
    </EncryptedKey>
  </KeyInfo>
  <CipherData>
    <CipherValue>CipherValueHere</CipherValue>
  </CipherData>
</EncryptedData>

How can I update my transform to replace the entire connection strings section with this? Is there a locator for the element name "connectionStrings"?

Many thanks, John

Agustin Meriles · Accepted Answer · 2017-08-07 18:54:11Z

7

To replace entire connectionString section use the below code

<connectionStrings xdt:Transform="Replace">

xdt:Transform="Replace" Will do the trick. Cheers!!

edited Aug 7, 2017 at 18:54

Agustin Meriles

4,8603 gold badges32 silver badges45 bronze badges

answered Apr 28, 2016 at 7:23

Mahesh

711 silver badge3 bronze badges

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

Comments

John Mc · Accepted Answer · 2013-09-09 10:24:07Z

4

Never mind, if you leave out the Locator it automatically applies it to the element.

answered Sep 9, 2013 at 10:24

John Mc

2,9431 gold badge26 silver badges37 bronze badges

Collectives™ on Stack Overflow

.Net Web.Config Transformations, replace entire ConnectionString section

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related