Enabling Exception Handling using Log4net

CREATE TABLE [dbo].[error_log](

 [Id] [int] IDENTITY(1,1) NOT NULL,

 [Date] [datetime] NOT NULL,

 [Thread] [varchar](255) NOT NULL,

 [Level] [varchar](50) NOT NULL,

 [Logger] [varchar](255) NOT NULL,

 [Message] [varchar](4000) NOT NULL,

 [Exception] [varchar](2000) NULL,

 CONSTRAINT [PK_error_log] PRIMARY KEY CLUSTERED 

(

 [Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

configSections>

    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />

  </configSections>

<appSettings>

    <add key="log4net.Internal.Debug" value="true" />

</appSettings>

<log4net>

    <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">

      <bufferSize value="1" />

      <filter type="log4net.Filter.LevelMatchFilter">

        <acceptOnMatch value="true" />

        <levelToMatch value="ERROR" />

      </filter>

      <filter type="log4net.Filter.DenyAllFilter" />

      <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

      <connectionStringName value="AverosAVL" />

      <commandText value="INSERT INTO error_log ([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>

      <appender-ref ref="AdoNetAppender" />

    </root>

  </log4net>