mssql写入mysql_.Net5 core Nlog 写入 mssqlserver 数据库

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

autoReload="true"

throwExceptions="true"

internalLogLevel="warn"

internalLogFile="logfiles/internal-nlog.txt">

fileName="${basedir}/logs/${level}/${shortdate}.log"

layout="${longdate}|${level:uppercase=true}|${logger}|${message}" />

dbProvider="System.Data.SqlClient"

connectionString="Data Source=127.0.0.1;Initial Catalog=ss;User ID=sa;Password=">

insert into NLog (

Application, Logged, Level, Message,

Logger, CallSite, Exception

) values (

@Application, @Logged, @Level, @Message,

@Logger, @Callsite, @Exception

);

CREATE TABLE [dbo].[NLog](

[Id] [bigint] IDENTITY(1,1) NOT NULL,

[Application] [nvarchar](50) NOT NULL,

[Logged] [datetime] NOT NULL,

[Level] [nvarchar](50) NOT NULL,

[Message] [nvarchar](max) NOT NULL,

[Logger] [nvarchar](250) NULL,

[Callsite] [nvarchar](max) NULL,

[Exception] [nvarchar](max) NULL

) ON [PRIMARY]