log4net 在access数据库中的 输出 测试

<?xml version="1.0" encoding="utf-8" ?><configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net-net-1.0"/> </configSections> <log4net> <root> <level value="ALL" /> <appender-ref ref="AdoNetAppender" /> </root> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"> <bufferSize value="0" /> <connectionString value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/myacces.mdb;" /> <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="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%date" /> </layout> </parameter> <parameter> <parameterName value="@thread" /> <dbType value="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%thread" /> </layout> </parameter> <parameter> <parameterName value="@log_level" /> <dbType value="String" /> <size value="4000" /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern value="%level" /> </layout> </parameter> <parameter> <parameterName value="@logger" /> <dbType value="String" /> <size value="4000" /> <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="4000" /> <layout type="log4net.Layout.ExceptionLayout" /> </parameter> </appender> </log4net></configuration> 

log4net.xml

 

配置文件:

AssemblyInfo.cs中最后添加：

[assembly: log4net.Config.DOMConfigurator(ConfigFile = "log4net.xml", Watch = true)]

主程序main中：

static void Main() { log4net.LogManager.GetLogger(typeof(Program)).Warn(DateTime.Now); log4net.LogManager.GetLogger(typeof(Program)).Info(DateTime.Now); log4net.LogManager.GetLogger(typeof(Program)).Error("ss", new NotImplementedException("not ImplementedException")); log4net.LogManager.GetLogger(typeof(Program)).Debug(DateTime.Now); log4net.LogManager.GetLogger(typeof(Program)).Fatal(DateTime.Now); Console.ReadKey(); } 

注意在自己的项目中添加log4net.dll

以上就是log4net在access数据库中的输出测试

另附一个牛人的说明介绍：

<?xml version="1.0" encoding="utf-8" ?><configuration><configSections><section name="log4net" type="System.Configuration.IgnoreSectionHandler"/></configSections><appSettings></appSettings><log4net><!--定义输出到文件中--><appender name="LogFileAppender" type="log4net.Appender.FileAppender"><!--定义文件存放位置--><file value="D:/log4netfile.txt" /><appendToFile value="true" /><rollingStyle value="Date" /><datePattern value="yyyyMMdd-HH:mm:ss" /><layout type="log4net.Layout.PatternLayout"><!--每条日志末尾的文字说明--><footer value="每条日志末尾的文字说明" /><!--输出格式--><!--样例：2008-03-26 13:42:32,111 [10] INFO Log4NetDemo.MainClass [(null)] - info--><conversionPattern value="记录时间：%date 线程ID:[%thread] 日志级别：%-5level 出错类：%logger property:[%property{NDC}] - 错误描述：%message%newline" /></layout></appender><!--定义输出到控制台命令行中--><appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender"><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" /></layout></appender><!--定义输出到windows事件中--><appender name="EventLogAppender" type="log4net.Appender.EventLogAppender"><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" /></layout></appender><!--定义输出到数据库中，这里举例输出到Access数据库中，数据库为C盘的log4net.mdb--><appender name="AdoNetAppender_Access" type="log4net.Appender.AdoNetAppender"><connectionString value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/log4net.mdb" /><commandText value="INSERT INTO LogDetails ([LogDate],[Thread],[Level],[Logger],[Message]) VALUES (@logDate, @thread, @logLevel, @logger,@message)" /><!--定义各个参数--><parameter><parameterName value="@logDate" /><dbType value="String" /><size value="240" /><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%date" /></layout></parameter><parameter><parameterName value="@thread" /><dbType value="String" /><size value="240" /><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%thread" /></layout></parameter><parameter><parameterName value="@logLevel" /><dbType value="String" /><size value="240" /><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%level" /></layout></parameter><parameter><parameterName value="@logger" /><dbType value="String" /><size value="240" /><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%logger" /></layout></parameter><parameter><parameterName value="@message" /><dbType value="String" /><size value="240" /><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%message" /></layout></parameter></appender><!--定义日志的输出媒介，下面定义日志以四种方式输出。也可以下面的按照一种类型或其他类型输出。--><root><!--文件形式记录日志--><appender-ref ref="LogFileAppender" /><!--控制台控制显示日志--><appender-ref ref="ConsoleAppender" /><!--Windows事件日志--><appender-ref ref="EventLogAppender" /><!-- 如果不启用相应的日志记录，可以通过这种方式注释掉--> <appender-ref ref="AdoNetAppender_Access" /> </root></log4net></configuration>