winformpe配置log4net使用sqlite存储日志

 

 

1.安装log4net 

2.新建log4net.config 配置参考官方示例；

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<configSections>
		<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
	</configSections>
	<startup>
		<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
	</startup>
	<log4net>
		<logger name="CodeLog">
			<level value="INFO" />
			<appender-ref ref="RollingLog" />
			<appender-ref ref="SqliteAppender" />
			<appender-ref ref="ColoredConsoleAppender" />
		</logger>
		<appender name="RollingLog" type="log4net.Appender.RollingFileAppender">
			<file value="WindowsServiceLog\" />
			<appendToFile value="true" />
			<rollingStyle value="Date" />
			<datePattern value="yyyyMMdd'.txt'" />
			<staticLogFileName value="false" />
			<layout type="log4net.Layout.PatternLayout">
				<conversionPattern value="记录时间：%d 线程ID:[%thread]- 操作信息：%m%n" />
			</layout>
			<filter type="log4net.Filter.LevelRangeFilter">
				<param name="LevelMin" value="INFO" />
				<param name="LevelMax" value="INFO" />
			</filter>
		</appender>
		<!--sqlite数据库-->
		<appender name="SqliteAppender" type="log4net.Appender.AdoNetAppender">
			<bufferSize value="1" />
			<param name="Threshold" value="INFO" />
			<connectionType value="System.Data.SQLite.SQLiteConnection, System.Data.SQLite" />
			<connectionString value="Data Source=D:/testDB.db;Version=3;" />
			<commandText value="INSERT INTO Log (Date, Level, Logger, Message) VALUES (@Date, @Level, @Logger, @Message)" />
			<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="@Message" />
				<dbType value="String" />
				<layout type="log4net.Layout.PatternLayout">
					<conversionPattern value="%message" />
				</layout>
			</parameter>
		</appender>
		<!--控制台-->
		<appender name="ColoredConsoleAppender"  type="log4net.Appender.ColoredConsoleAppender" >
			<mapping>
				<level value="DEBUG" />
				<backColor value="Green" />
			</mapping>
			<layout type="log4net.Layout.PatternLayout">
				<param name="ConversionPattern" value="%d [%t] %F-%L-%c/%p--message:%m%n" />
				<!--<param name="ConversionPattern"  value="%n%d 程序运行时间:%r毫秒 进程ID:%t 行号:%L %n 当前日志对象名称:%c 日志当前级别:%p 输出语句所在文件名:%F 日志消息:%m" />-->
			</layout>
		</appender>
	</log4net>
</configuration>

3.入口文件中读取配置文件

 log4net.Config.XmlConfigurator.ConfigureAndWatch(new FileInfo("log4net.config"));

4.程序内使用

log4net.ILog ILog = log4net.LogManager.GetLogger("MdTools.Logging");
ILog.error("123")