log4net寫入日誌到sqlserver資料庫

標籤：分享   help   expr   manage   啟動   std   程式   建立   自動   

1、添加log4Net設定檔log4net.config  

　　設定檔屬性設定為：

　　配置如下：

<?xml version="1.0" encoding="utf-8"?><log4net debug="false">  <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">    <bufferSize value="2" />    <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089" />    <connectionString value="Data Source=.\SQLExpress;Initial Catalog=testDb;Integrated Security=true" />    <commandText value="INSERT INTO SysLogs ([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="ALL" />    <appender-ref ref="AdoNetAppender" />  </root></log4net>

2.在資料庫建立SysLogs表

3.webConfig 配置

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

4.應用程式啟動時設定配置項  Global.asax

   protected void Application_Start()        {            //應用程式啟動時，自動載入配置log4Net              XmlConfigurator.Configure();        }

5.日誌寫入樣本

public static class LogHelp    {        public static void WriteError(Exception ex)        {            ILog log = log4net.LogManager.GetLogger("Log");            log.Error(ex.Message, ex);        }    }

 

log4net寫入日誌到sqlserver資料庫