.Net
Core2.1+
NLog+数据库连接
<?xml version="1.0" encoding="utf-8" ?>
<
nlog
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
autoReload="true"
throwExceptions="true"
internal
LogLevel="warn"
internal
LogFile="
logfiles/internal-
nlog.txt">
<targets>
<target xsi:type="Null" name="blackhole" />
<target name="database" xsi:type="Database"
dbProvider="System.Data.SqlClient"
connectionString="Data Source=127.0.0.1;Initial Cata
log=MiddleData;User ID=lzhu;Password=bl123456;"
>
<!--
create table
NLog (
Id int identity,
Application nvarchar(50) null,
Logged datetime null,
Level nvarchar(50) null,
Message nvarchar(512) null,
Logger nvarchar(250) null,
Callsite nvarchar(512) null,
Exception nvarchar(512) null,
constraint PK_
NLOG primary key (Id)
)
-->
<commandText>
insert into
nlog (
Application,
Logged, Level, Message,
Logger, CallSite, Exception
) values (
@Application, @
Logged, @Level, @Message,
@
Logger, @Callsite, @Exception
);
</commandText>
<parameter name="@application" layout="
NLogTestDemo" />
<parameter name="@
logged" layout="${date}" />
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
<parameter name="@
logger" layout="${
logger}" />
<parameter name="@callSite" layout="${callsite:filename=true}" />
<parameter name="@exception" layout="${exception:tostring}" />
</target>
</targets>
<rules>
<!--Skip Microsoft
logs and so
log only own
logs-->
<
logger name="Microsoft.*" minlevel="Trace" writeTo="blackhole" final="true" />
<
logger name="
NLogTestDemo.*" minlevel="Info" writeTo="database" />
</rules>
</
nlog>
838
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
