title: Records delayed in log4net AdoNetAppender?
body: <p>I have an <code>AdoNetAppender</code> setup like this:</p>
  
  <pre class="lang-xml prettyprint-override"><code>  &lt;log4net&gt;
      &lt;appender name="AdoNetAppender_SqlServer" type="log4net.Appender.AdoNetAppender"&gt;
        &lt;connectionStringName value="DefaultConnection" /&gt;
        &lt;connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
        &lt;commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" /&gt;
        &lt;useTransactions value="false" /&gt;
        &lt;parameter&gt;
          &lt;parameterName value="@log_date" /&gt;
          &lt;dbType value="DateTime" /&gt;
          &lt;layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /&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" value="%thread" /&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" value="%level" /&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" value="%logger" /&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" value="%message" /&gt;
        &lt;/parameter&gt;
      &lt;/appender&gt;
  
      &lt;root&gt;
        &lt;level value="DEBUG" /&gt;
        &lt;appender-ref ref="AdoNetAppender_SqlServer" /&gt;
      &lt;/root&gt;
    &lt;/log4net&gt;
  </code></pre>
  
  <p>And technically it works because when I stop the website that's running on IIS 8 Express locally the records show up. <strong><em>However, that's exactly the problem, the records don't show up until I stop the website.</em></strong></p>
  
  <p>I've tried with <code>useTransactions</code> on and off.</p>
  
  <p>Can somebody help with this?</p>