ASP.NET Core使用NLog记录日志到Microsoft Sql Server

<?xml version="1.0" encoding="utf-8" ?> 2 <nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 autoReload="true" 5 internalLogLevel="Warn" 6 internalLogFile="logfiles/internal-nlog.txt"> 7 8 <!-- define various log targets --> 9 <targets> 10 <!-- write logs to file --> 11 <target xsi:type="File" name="allfile" fileName="${var:configDir}\nlog-all.log" 12 layout="${longdate}|${event-properties:item=EventId.Id}|${logger}|${uppercase:${level}}|${message} ${exception}" /> 13 14 15 <target xsi:type="File" name="ownFile-web" fileName="${var:configDir}\nlog-own.log" 16 layout="${longdate}|${event-properties:item=EventId.Id}|${logger}|${uppercase:${level}}| ${message} ${exception}" /> 17 18 <target xsi:type="Null" name="blackhole" /> 19 20 <target name="database" xsi:type="Database"> 21 22 <connectionString>${var:connectionString}</connectionString> 23 24 25 <commandText> 26 insert into dbo.Log ( 27 Application, Logged, Level, Message, 28 Logger, Callsite, Exception 29 ) values ( 30 @Application, @Logged, @Level, @Message, 31 @Logger, @Callsite, @Exception 32 ); 33 </commandText> 34 35 <parameter name="@application" layout="AspNetCoreNlog" /> 36 <parameter name="@logged" layout="${date}" /> 37 <parameter name="@level" layout="${level}" /> 38 <parameter name="@message" layout="${message}" /> 39 40 <parameter name="@logger" layout="${logger}" /> 41 <parameter name="@callSite" layout="${callsite}" /> 42 <parameter name="@exception" layout="${exception:tostring}" /> 43 </target> 44 </targets> 45 46 <rules> 47 <!--All logs, including from Microsoft--> 48 <logger name="*" minlevel="Trace" writeTo="allfile" /> 49 50 <!--Skip Microsoft logs and so log only own logs--> 51 <logger name="Microsoft.*" minlevel="Trace" writeTo="blackhole" final="true" /> 52 <logger name="*" minlevel="Trace" writeTo="database" /> 53 <logger name="*" minlevel="Trace" writeTo="ownFile-web" /> 54 </rules> 55 </nlog>

3.将nlog.config复制到bin文件夹

 

4.设置数据库(我使用的是ef code first方式创建数据表)

 1 using System;
 2 
 3 namespace Apps.Models
 4 {
 5     public class ApplicationLog
 6     {
 7         public int Id { get; set; }
 8         public string Application { get; set; }
 9         public DateTime Logged { get; set; }
10         public string Level { get; set; }
11         public string Message { get; set; }
12         public string Logger { get; set; }
13         public string Callsite { get; set; }
14         public string Exception { get; set; }
15     }
16 }

 1         protected override void OnModelCreating(ModelBuilder builder)
 2         {
 3             builder.Entity<ApplicationLog>(m =>
 4             {
 5                 m.ToTable("Log");
 6                 m.HasKey(c => c.Id);
 7                 m.Property(c => c.Application).IsRequired().HasMaxLength(50);
 8                 m.Property(c => c.Level).IsRequired().HasMaxLength(50);
 9                 m.Property(c => c.Message).IsRequired();
10                 m.Property(c => c.Logger).HasMaxLength(250);
11             });
12         }

5.在startup.cs文件中添加:

 1 using NLog.Extensions.Logging;
 2 using NLog.Web;
 3 
 4 public Startup(IHostingEnvironment env)
 5 {
 6     env.ConfigureNLog("nlog.config");
 7 }
 8 
 9 // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
10 public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
11 {
12 
13 
14     loggerFactory.AddNLog();
15 
16     app.AddNLogWeb();
17     LogManager.Configuration.Variables["connectionString"] = Configuration.GetConnectionString("DefaultConnection");
18     LogManager.Configuration.Variables["configDir"] = Configuration.GetSection("LogFilesDir").Value;
19 }

6.appsettings.json

  "ConnectionStrings": {
    "DefaultConnection": "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=logdb;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
  },
  "LogFilesDir": "c:\\temp\\nlog\\logfiles" 

7.然后就可以记录日志了

 1     public class HomeController :Controller {
 2         private readonly ILogger _logger;
 3 
 4         public HomeController(ILoggerFactory loggerFactory) {
 5             _logger = loggerFactory.CreateLogger<HomeController>();
 6         }
 7         public IActionResult Index() {
 8             _logger.LogInformation("你访问了首页");
 9             _logger.LogWarning("警告信息");
10             _logger.LogError("错误信息");
11             return View();
12         }
13 　　}

ASP.NET Core使用NLog记录日志到Microsoft Sql Server

标签：oge   alt   manager   .sql   conf   rust   max   分享   elb