title: log4Net config transform
body: <p>I am able to transform my log4net.config but I am not getting this one. How do I change the following connectionString? </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
      &lt;configuration&gt;
        &lt;log4net debug="true"&gt;
          &lt;root&gt;
            &lt;level value="ALL" /&gt;
          &lt;/root&gt; 
          &lt;logger name="MyApp"&gt;
            &lt;level value="Debug" /&gt;
             &lt;appender-ref ref="RollingLogFileAppender" /&gt;
             &lt;appender-ref ref="AdoNetAppender" /&gt;
          &lt;/logger&gt;
          &lt;appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender"&gt;
                  &lt;file value="C:\Websites\Logs\SiteLog.txt"/&gt;
                  &lt;appendToFile value="true"/&gt;
                  &lt;rollingStyle value="Date"/&gt;
                  &lt;datePattern value="yyyyMMdd.txt"/&gt;
                  &lt;layout type="log4net.Layout.PatternLayout"&gt;
                      &lt;conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline"/&gt;
                  &lt;/layout&gt;
              &lt;/appender&gt;
          &lt;appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"&gt;
            &lt;bufferSize value="1" /&gt;
            &lt;connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
            &lt;connectionString value="***Data Source=(local);initial catalog=MyDB;User ID=sa;Password=dbPassword***" /&gt;
  </code></pre>
  
  <p>The following does not work:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  
  &lt;configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform"&gt;
    &lt;log4net debug="false" 
             xdt:Transform="SetAttributes(debug)" /&gt;
    &lt;appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"&gt;
      &lt;connectionString value="Data Source=(local);initial catalog=RavenAxiom;User ID=ravenaxiom;Password=xyz" 
              xdt:Transform="SetAttributes(value)" /&gt;
    &lt;/appender&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>It changes the debug value so it partially works. Thank for the help.</p>
  
  <p>Jack</p>