Log4Net不写入数据库,但工作
本文关键字:工作 数据库 Log4Net | 更新日期: 2023-09-27 18:13:10
我看了很多关于这个的线程,我似乎看不出为什么我的代码不工作。我正在登录控制台和文件appender,但数据库日志从未工作。
我的app.config设置是:
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" requirePermission="false"/>
</configSections>
<!-- Log4net Logging Setup -->
<log4net>
<appender name="Console" type="log4net.Appender.ConsoleAppender">
<threshold value="Debug" />
<layout type="log4net.Layout.PatternLayout">
<!-- Pattern to output the caller's file name and line number -->
<conversionPattern value="%5level [%thread] (%file:%line) - %message%newline" />
</layout>
</appender>
<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
<threshold value="Info" />
<file value="C:''Sample.txt" />
<appendToFile value="true" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="10" />
<maximumFileSize value="250KB" />
<staticLogFileName value="true" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<threshold value="Error" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<connectionString value="Connection_String"/>
<commandText value="MyStoredProc" />
<commandType value="StoredProcedure" />
<parameter name="AgentId">
<parameterName value="@AgentId"/>
<dbType value="String"/>
<size value="6"/>
<layout type="log4net.Layout.PatternLayout" value="%property{AgentId}" />
</parameter>
<parameter name="customerId">
<parameterName value="@customerId"/>
<dbType value="String"/>
<size value="15"/>
<layout type="log4net.Layout.PatternLayout" value="%property{customerId}" />
</parameter>
<parameter>
<parameterName value="@log"/>
<dbType value="String"/>
<size value="4000"/>
<layout type="log4net.Layout.PatternLayout" value="%message"/>
</parameter>
<parameter>
<parameterName value="@ErrorDate"/>
<dbType value="DateTime"/>
<layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}"/>
</parameter>
</appender>
<root>
<level value="ALL" />
<appender-ref ref="Console" />
<appender-ref ref="RollingFileAppender" />
<appender-ref ref="AdoNetAppender" />
</root>
</log4net>
c#代码是:
log4net.Config.BasicConfigurator.Configure();
log4net.ILog Log = log4net.LogManager.GetLogger(typeof(T));
log4net.LogicalThreadContext.Properties["AgentId"] = agentId;
log4net.LogicalThreadContext.Properties["customerId"] = custId;
Log.Error(String.Format("Non fatal error: {0} ({1})", ex.Message, ex.InnerException), ex);
您应该使用log4net.Config.XmlConfigurator.Configure()方法而不是log4net.Config.BasicConfigurator.Configure();
XmlConfigurator将读取您的配置,并使您能够按照配置记录到数据库。BasicConfigurator将只记录到您的控制台。