title: why the AdoNetAppender isnt writing log messages to the DB?
body: <p>I am using the AdoNetAppender
  and here is a portion of my config file:</p>
  
  <pre class="lang-xml prettyprint-override"><code> &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="[we will set this automatically at runtime]" /&gt;
    &lt;commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" /&gt;
     &lt;parameter&gt;
      &lt;parameterName value="@log_date"/&gt; &lt;dbType value="DateTime"/&gt; &lt;layout type="log4net.Layout.RawTimeStampLayout"/&gt;
    &lt;/parameter&gt;
         &lt;parameter&gt;
      &lt;parameterName value="@thread"/&gt; &lt;dbType value="String"/&gt; &lt;size value="255"/&gt; &lt;layout type="log4net.Layout.PatternLayout"&gt;
        &lt;conversionPattern value="%thread"/&gt;
      &lt;/layout&gt;
    &lt;/parameter&gt;
    &lt;parameter&gt;
       &lt;parameterName value="@log_level"/&gt; &lt;dbType value="String"/&gt; &lt;size value="50"/&gt; &lt;layout type="log4net.Layout.PatternLayout"&gt;
        &lt;conversionPattern value="%level"/&gt;
      &lt;/layout&gt;
    &lt;/parameter&gt;
     &lt;parameter&gt;
       &lt;parameterName value="@logger"/&gt; &lt;dbType value="String"/&gt; &lt;size value="255"/&gt; &lt;layout type="log4net.Layout.PatternLayout"&gt;
        &lt;conversionPattern value="%logger"/&gt;
      &lt;/layout&gt;
    &lt;/parameter&gt;
     &lt;parameter&gt;
       &lt;parameterName value="@message"/&gt; &lt;dbType value="String"/&gt; &lt;size value="4000"/&gt; &lt;layout type="log4net.Layout.PatternLayout"&gt;
        &lt;conversionPattern value="%message"/&gt;
      &lt;/layout&gt;
    &lt;/parameter&gt;
     &lt;parameter&gt;
       &lt;parameterName value="@exception"/&gt; &lt;dbType value="String"/&gt; &lt;size value="2000"/&gt; &lt;layout type="log4net.Layout.ExceptionLayout"/&gt;
    &lt;/parameter&gt;
  &lt;/appender&gt;
  </code></pre>
  
  <p>and this is my code to log messages:</p>
  
  <pre><code> private static readonly ILog fifthlog = LogManager.GetLogger("ADONetAppender"); fifthlog.Info("this is db log");
  </code></pre>
  
  <p>I'm also using other appenders like RollingFileAppender, and they are working perfectly but this one doesn't, because when I do this query <code>select * from Log</code> in my sql server the table is empty. My db connection is successful because I tested the connection. What's wrong?</p>