DEMO：/Files/chiyung/sample.rar
ASP.NET中使用Log4Net將日志寫到Sqlite中，有可能需要增加訪客IP或訪問地址記錄到數(shù)據(jù)庫獨立字段．
效果如下：
建一個類庫為：
log4net.Ext.Web
添加以下３個類：
IWebLog.cs
WebLogImpl.cs
WebLogManager.cs
代碼大概這樣，log4net里面有很詳細的參考：
IWebLog.cs
using System;
using log4net;
namespace log4net.Ext.Web
{
public interface IWebLog : ILog
{
void Info(string clientIP, string requestUrl, object message);
void Info(string clientIP, string requestUrl, object message, Exception t);
void Warn(string clientIP, string requestUrl, object message);
void Warn(string clientIP, string requestUrl, object message, Exception t);
void Error(string clientIP, string requestUrl, object message);
void Error(string clientIP, string requestUrl, object message, Exception t);
void Fatal(string clientIP, string requestUrl, object message);
void Fatal(string clientIP, string requestUrl, object message, Exception t);
}
}log4net的配置，ConnectionType需要根據(jù)數(shù)據(jù)庫驅(qū)動配置正確，如果你使用的是其它SQLiteADO.NET驅(qū)動：
log.xml
<?xml version="1.0" encoding="utf-8"?>
<log4net>
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="0" />
<connectionType value="System.Data.SQLite.SQLiteConnection, System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
<connectionString value="Data Source=|DataDirectory|log.s3db;Version=3;" />
<commandText value="INSERT INTO Log (Date, Level, Logger, ClientIP, RequestUrl, Message, Exception) VALUES (@Date, @Level, @Logger, @ClientIP, @RequestUrl, @Message, @Exception)" />
<parameter>
<parameterName value="@Date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value="@Level" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value="@Logger" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<parameter>
<parameterName value="@ClientIP" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{ClientIP}" />
</layout>
</parameter>
<parameter>
<parameterName value="@RequestUrl" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{RequestUrl}" />
</layout>
</parameter>
<parameter>
<parameterName value="@Message" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
<parameter>
<parameterName value="@Exception" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%exception" />
</layout>
</parameter>
</appender>
<root>
<level value="ALL"/>
<appender-ref ref="AdoNetAppender"/>
</root>
</log4net> 使用：
Global.asax
private static readonly IWebLog WebLog = WebLogManager.GetLogger("Application_Error");
void Application_Start(object sender, EventArgs e)
{
//在應用程序啟動時運行的代碼
log4net.Config.DOMConfigurator.Configure(new FileInfo(Server.MapPath("~/log.xml")));
}
void Application_End(object sender, EventArgs e)
{
//在應用程序關(guān)閉時運行的代碼
}
void Application_Error(object sender, EventArgs e)
{
//在出現(xiàn)未處理的錯誤時運行的代碼
Exception exception = Server.GetLastError().InnerException;
WebLog.Error(Request.UserHostAddress, Request.Url.ToString(), exception.Message, exception);
}
protected void Page_Load(object sender, EventArgs e)
{
throw new Exception("the message.");
}
Tag標簽: log4net,sqlite,擴展
