Log4Net把日志保存到数据库和发送Email

1. 建立数据库的表和存储过程

CREATE TABLE [dbo].[LogTest] ( [LogID] [int] IDENTITY (1, 1) NOT NULL , [LogDate] [datetime] NOT NULL , [LogThread] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [LogLevel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Logger] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [LogMessage] [varchar] (4000) COLLATE Chinese_PRC_CI_AS NULL , [LogException] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO

 

CREATE PROCEDURE dbo.spLog_Create @log_date datetime, @thread varchar(255), @log_level varchar(50), @logger varchar(255), @message varchar(4000), @exception varchar(2000)asINSERT INTO LogTest ( LogDate, LogThread, LogLevel, Logger, LogMessage, LogException ) VALUES ( @log_date, @thread, @log_level, @logger, @message, @exception )GO

 

 

2. Log4Net的配置

在Web.Config或App.Config文件的<configSections>段中增加:

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

 

在<configSections>段后增加:

<log4net> <appender name="MyADO" type="log4net.Appender.ADONetAppender"> <param name="BufferSize" value="100" /> <param name="ConnectionType" value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <param name="ConnectionString" value="Server=localhost;Database=HanTest;User ID=sa;Password=suypower;Trusted_Connection=False" /> <param name="CommandType" value="StoredProcedure" /> <param name="CommandText" value="spLog_Create" /> <param name="Parameter"> <param name="ParameterName" value="@log_date" /> <param name="DbType" value="DateTime" /> <param name="Layout" type="log4net.Layout.RawTimeStampLayout" /> </param> <param name="Parameter"> <param name="ParameterName" value="@thread" /> <param name="DbType" value="String" /> <param name="Size" value="255" /> <param name="Layout" type="log4net.Layout.PatternLayout"> <param name="ConversionPattern" value="%t" /> </param> </param> <param name="Parameter"> <param name="ParameterName" value="@log_level" /> <param name="DbType" value="String" /> <param name="Size" value="50" /> <param name="Layout" type="log4net.Layout.PatternLayout"> <param name="ConversionPattern" value="%p" /> </param> </param> <param name="Parameter"> <param name="ParameterName" value="@logger" /> <param name="DbType" value="String" /> <param name="Size" value="255" /> <param name="Layout" type="log4net.Layout.PatternLayout"> <param name="ConversionPattern" value="%c" /> </param> </param> <param name="Parameter"> <param name="ParameterName" value="@message" /> <param name="DbType" value="String" /> <param name="Size" value="4000" /> <param name="Layout" type="log4net.Layout.PatternLayout"> <param name="ConversionPattern" value="%m" /> </param> </param> <param name="Parameter"> <param name="ParameterName" value="@exception" /> <param name="DbType" value="String" /> <param name="Size" value="2000" /> <param name="Layout" type="log4net.Layout.ExceptionLayout" /> </param> </appender> <appender name="SMTPAppender" type="log4net.Appender.SMTPAppender"> <BufferSize value="1" /> <param name="To" value="[e-mail]" /> <param name="From" value="[e-mail]" /> <Subject value="log4net Error Message" /> <SMTPHost value="172.23.23.26" /> <Username value="hansong" /> <Password value="1234" /> <param name="LocationInfo" value="false" /> <param name="BufferSize" value="512" /> 说明: "BufferSize"设置日志缓存,存储到512后一起一个Email发送,如不设此项,每记一个日志,发一条Email <!-- <param name="Lossy" value="true" /> <evaluator type="log4net.spi.LevelEvaluator"> <param name="Threshold" value="WARN" /> </evaluator> --> <layout type="log4net.Layout.PatternLayout"> <param name="ConversionPattern" value="%n%d [%t] %-5p %c [%x] - %m%n%n%n" /> </layout> </appender> <root> <level value="ALL" /> <appender-ref ref="MyADO" /> <appender-ref ref="SMTPAppender" /> </root> </log4net>

 

 

3. 在AssemblyInfo.cs文件中加入以下行:

[assembly:log4net.Config.DOMConfigurator( ConfigFileExtension="config",Watch=true)]

 

 

4. 编写测试代码:

log4net.ILog log = log4net.LogManager.GetLogger("MyLoggerTest"); try{ log.Info("这是hansong的LOG INFO测试!"); log.Debug("这是hansong的LOG DEBUG测试!"); throw new Exception("这是hansong的LOG ERROR测试!");}catch(Exception er){ log.Error("错误日志",er);}