成功利用Log4net将日志写入数据库！

经过这两天的调试终于把日志成功的写入了数据库中，现在回过头来发现走了好多弯路，做了好多无用功呀。

 

写入数据库时的appender 配置：

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
   <bufferSize value="1" />
   <connectionType value="System.Data.SqlClient.SqlConnection, System.Data,Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
   <connectionString value="Data Source=.;Initial Catalog=HJRightPlat;User ID=sa;Password=123456" />
    <commandText value="INSERT INTO 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>

  <appender name="ConsoleAppender"  type="log4net.Appender.ConsoleAppender" >
   <layout type="log4net.Layout.PatternLayout">
    <param name="ConversionPattern"  value="%d [%t] %-5p %c [%x] - %m%n" />
   </layout>
  </appender>

 

 

开始我一直以为：System.Data.SqlClient.SqlConnection, System.Data,Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089这句话出问题了，绕了半天，

可结果是：data source=[XFH-PC];initial catalog=[HJRightPlat];integrated security=false;persist security info=True;User ID=[sa];Password=123456  这句话有问题，把它改成：Data Source=.;Initial Catalog=HJRightPlat;User ID=sa;Password=123456"就OK了，