Issue using Log4Net Databse Appender

See more:

C#

ASP.NET

Hi All,

I am using Log4Net to log the exception in database.

When i log any error using log.Error("Error message");.

No row inserted in database until I restart the application or made changes in database.

Is there is any way insert error immediately in database after the error occurred.

My configuration for Database appender is

<log4net>
    <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">     
      <connectiontype value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      <connectionstring value="data source=RTPC02;initial catalog=Test;integrated security=false;persist security info=True;User ID=sa;Password=sa" />
      <commandtext value="INSERT INTO ErrorLog ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
      <parameter>
        <parametername value="@log_date" />
        <dbtype value="DateTime" />
        <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
        <parametername value="@thread" />
        <dbtype value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionpattern value="%thread" />
        </layout>
      </parameter>
      <parameter>
        <parametername value="@log_level" />
        <dbtype value="String" />
        <size value="50" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionpattern value="%level" />
        </layout>
      </parameter>
      <parameter>
        <parametername value="@logger" />
        <dbtype value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionpattern value="%logger" />
        </layout>
      </parameter>
      <parameter>
        <parametername value="@message" />
        <dbtype value="String" />
        <size value="4000" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionpattern value="%message" />
        </layout>
      </parameter>
      <parameter>
        <parametername value="@exception" />
        <dbtype value="String" />
        <size value="2000" />
        <layout type="log4net.Layout.ExceptionLayout" />
      </parameter>
    </appender>
    <root>
      <level value="ERROR" />
      <appender-ref ref="AdoNetAppender" />
    </root>
  </log4net>