title: log4net AdoNetAppender truncating message text
body: <p>I have an issue where my message field is being truncated to roughly 42k no matter what I do. </p>
  
  <p>Here's a short snippet to illustrate my configuration: </p>
  
  <pre><code>&lt;log4net&gt;
      &lt;appender name="DbLogs" type="log4net.Appender.AdoNetAppender"&gt;
        &lt;connectionType value="..." /&gt;
        &lt;bufferSize value="0"/&gt;
        &lt;filter type="log4net.Filter.LevelRangeFilter"&gt;
          &lt;levelMin value="INFO" /&gt;
        &lt;/filter&gt;
        &lt;filter type="log4net.Filter.DenyAllFilter" /&gt;
        &lt;connectionString value="Data Source=..." /&gt;
        &lt;commandText value="INSERT INTO Logs ([Date],[Thread],[Level],[Logger],[Line],[Location],[Type],[Message],[Exception], [Username], [Guid]) VALUES (@log_date, @thread, @log_level, @logger, @line, @location, @type, @message, @exception, @current_username, @current_guid)" /&gt;
        &lt;parameter&gt;
          ...
        &lt;/parameter&gt;
        ...
        &lt;parameter&gt;
          &lt;parameterName value="@message" /&gt;
          &lt;dbType value="String" /&gt;
          &lt;size value="-1" /&gt;
          &lt;layout type="log4net.Layout.PatternLayout"&gt;
            &lt;conversionPattern value="%message" /&gt;
          &lt;/layout&gt;
        &lt;/parameter&gt;
        ...
      &lt;/appender&gt;
      &lt;root&gt;
        &lt;level value="INFO" /&gt;
        &lt;appender-ref ref="DbLogs" /&gt;
      &lt;/root&gt;
    &lt;/log4net&gt;
  </code></pre>
  
  <p>For the message parameter I've tried the size value "-1", "9999999" which made absolutely no difference, it always stores only 42k. 0 rightfully throws an exception. </p>
  
  <p>I also tried removing the size element altogether but that through an exception. </p>
  
  <p>For the dbType I tried AnsiString as well, but had no luck there. </p>
  
  <p>The message field in the Logs table is defined as a varchar(MAX)</p>
  
  <pre><code>Message varchar(MAX)
  </code></pre>
  
  <p>DB: SQL Server 2012
  Log4net: 1.2.11
  .net Framework: 4.0</p>
  
  <p>Any ideas? </p>