.Net使用Log4Net获取系统日志并写入数据库_linux清空正在写入的日志资源-CSDN文库

共709个文件

dll：250个

xml：75个

pp：48个

.net

log4net

4星 · 超过85%的资源需积分: 50 2 浏览量 2018-09-18 15:21:07 上传评论 6 收藏 46.91MB RAR 举报

在.NET开发过程中，日志记录是一项至关重要的任务，它帮助开发者追踪程序运行状态，尤其是在遇到异常和错误时，日志信息能提供宝贵的诊断线索。Log4Net是Apache组织提供的一个强大的日志框架，广泛应用于.NET应用程序，以实现灵活、可扩展的日志记录功能。本文将详细介绍如何使用Log4Net来捕获和记录系统的异常信息，并将其存储到Sql Server数据库中。我们需要在项目中引入Log4Net库。可以通过NuGet包管理器来安装Log4Net，或者手动添加对log4net.dll的引用。安装完成后，要在应用程序的配置文件（如web.config或app.config）中进行配置，设置日志输出级别、Appender（日志输出目的地）以及相关的连接字符串等信息。例如： ```xml <configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/> </configSections> <log4net> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <connectionString value="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;" /> <commandText value="INSERT INTO ErrorLog (Date, Thread, Level, Logger, Message, Exception) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" /> <parameter> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout type="log4net.Layout.RawTimeStampLayout" /> </parameter>  </appender> <root> <level value="ALL" /> <appender-ref ref="AdoNetAppender" /> </root> </log4net> </configuration> ``` 接下来，我们需要在代码中初始化Log4Net，通常在应用程序启动时进行： ```csharp using log4net; using log4net.Config; [assembly: log4net.Config.XmlConfigurator(Watch = true)] ``` 然后，在需要记录日志的地方，我们可以创建一个日志实例，并调用相应的方法记录信息。例如，当捕获到一个异常时，可以这样记录： ```csharp private static readonly ILog log = LogManager.GetLogger(typeof(MyClass)); try { // 代码可能会抛出异常 } catch (Exception ex) { log.Fatal("发生致命错误", ex); } ``` 上述代码中的`log.Fatal`方法会记录一个严重级别的日志条目，包含错误消息和异常堆栈信息。Log4Net支持多种日志级别，包括DEBUG、INFO、WARN、ERROR和FATAL，可以根据实际需求选择合适的级别。在上述配置中，我们设置了AdoNetAppender，它将日志信息存储到SQL Server数据库的ErrorLog表中。如果需要，可以自定义表结构，以便包含更多相关信息，如机器名、用户名等。此外，Log4Net还支持其他类型的Appender，如文件Appender、控制台Appender和SMTP Appender等，可以根据需要进行组合使用。总结起来，通过Log4Net，我们可以方便地在.NET应用中捕获异常信息并将其存储到数据库中，便于后期分析和调试。Log4Net的灵活性和可配置性使其成为.NET开发中不可或缺的工具，帮助开发者实现高效、可靠的日志记录。在项目实践中，根据具体需求调整配置和日志级别，可以有效提升问题定位和解决的速度。

资源推荐

资源详情

资源评论

收起资源包目录

.Net 使用Log4Net 获取系统日志并写入数据库（709个子文件）

_._ 0B

Global.asax 106B

Log4NetTest.csprojAssemblyReference.cache 205KB

DesignTimeResolveAssemblyReferencesInput.cache 19KB

Log4NetTest.csproj.CoreCompileInputs.cache 42B

applicationhost.config 84KB

csi.exe.config 9KB

VBCSCompiler.exe.config 8KB

vbc.exe.config 8KB

csc.exe.config 8KB

vbc.exe.config 8KB

csc.exe.config 8KB

vbc.exe.config 8KB

csc.exe.config 8KB

ApplicationInsights.config 7KB

Log4Net.config 6KB

Log4Net.config 5KB

Web.config 5KB

Log4NetTest.dll.config 5KB

Web.config 5KB

packages.config 3KB

Web.config 2KB

Web.Release.config 1KB

Web.config 1KB

Web.Debug.config 1KB

Log4NetTest.csproj.CopyComplete 0B

HelpPageConfigurationExtensions.cs 24KB

HelpPageSampleGenerator.cs 21KB

ObjectGenerator.cs 19KB

ModelDescriptionGenerator.cs 19KB

XmlDocumentationProvider.cs 7KB

HelpPageSampleKey.cs 6KB

HelpPageConfig.cs 6KB

HelpPageApiModel.cs 4KB

Net.cs 3KB

Log4NetFilterAttribute.cs 3KB

LogHelper.cs 3KB

HelpController.cs 2KB

LogEncapsulation.cs 2KB

ApiDescriptionExtensions.cs 2KB

AuditLogInfo.cs 1KB

ModelNameHelper.cs 1KB

AssemblyInfo.cs 1KB

ImageSample.cs 1KB

BundleConfig.cs 1KB

Global.asax.cs 1KB

InvalidSample.cs 1009B

TextSample.cs 923B

ValuesController.cs 851B

HelpPageAreaRegistration.cs 694B

RouteConfig.cs 604B

WebApiConfig.cs 601B

ModelNameAttribute.cs 579B

ParameterDescription.cs 562B

EnumTypeModelDescription.cs 419B

ComplexTypeModelDescription.cs 398B

HomeController.cs 396B

ModelDescription.cs 349B

FilterConfig.cs 279B

KeyValuePairModelDescription.cs 278B

IModelDocumentationProvider.cs 267B

EnumValueDescription.cs 253B

ParameterAnnotation.cs 242B

SampleDirection.cs 238B

CollectionModelDescription.cs 204B

DictionaryModelDescription.cs 150B

SimpleTypeModelDescription.cs 138B

TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs 0B

TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs 0B

TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs 0B

TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs 0B

TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs 0B

TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs 0B

Index.cshtml 2KB

HelpPageApiModel.cshtml 2KB

_Layout.cshtml 2KB

Parameters.cshtml 2KB

ApiGroup.cshtml 1KB

共 709 条

C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\ApplicationInsights.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Log4NetTest.dll.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Log4NetTest.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Log4NetTest.pdb C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csc.exe C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csc.exe.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csc.rsp C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csi.exe C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csi.exe.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\csi.rsp C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.Build.Tasks.CodeAnalysis.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CodeAnalysis.CSharp.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CodeAnalysis.CSharp.Scripting.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CodeAnalysis.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CodeAnalysis.Scripting.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CodeAnalysis.VisualBasic.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.CSharp.Core.targets C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.DiaSymReader.Native.amd64.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.DiaSymReader.Native.x86.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.VisualBasic.Core.targets C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\Microsoft.Win32.Primitives.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.AppContext.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Collections.Immutable.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Console.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Diagnostics.FileVersionInfo.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Diagnostics.Process.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Diagnostics.StackTrace.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.IO.Compression.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.IO.FileSystem.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.IO.FileSystem.DriveInfo.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.IO.FileSystem.Primitives.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.IO.Pipes.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Reflection.Metadata.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.AccessControl.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Claims.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Cryptography.Algorithms.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Cryptography.Encoding.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Cryptography.Primitives.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Cryptography.X509Certificates.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Security.Principal.Windows.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Text.Encoding.CodePages.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Threading.Thread.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.ValueTuple.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Xml.ReaderWriter.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Xml.XmlDocument.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Xml.XPath.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\System.Xml.XPath.XDocument.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\vbc.exe C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\vbc.exe.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\vbc.rsp C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\VBCSCompiler.exe C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\roslyn\VBCSCompiler.exe.config C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Antlr3.Runtime.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\log4net.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.Agent.Intercept.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.DependencyCollector.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.PerfCounterCollector.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.ServerTelemetryChannel.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.Web.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AI.WindowsServer.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.ApplicationInsights.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.AspNet.TelemetryCorrelation.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.CodeDom.Providers.DotNetCompilerPlatform.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4NetTest\bin\Microsoft.Web.Infrastructure.dll C:\Users\Administrator\Documents\Visual Studio 2017\Projects\Log4NetTest\Log4N

评论收藏

内容反馈