NLog正在写数据库，而不是文件

Question

我有这些目标:

<target xsi:type="File" name="myAppLoggerTarget" fileName="${basedir}/logs/${shortdate}.log"
layout="${longdate} ${uppercase:${level}} ${message}" />
<target xsi:type="Database"
name="myAppLoggerTarget"
connectionString="Data Source=R5-4500USQLEXPRESS;Initial Catalog=BlogDb;Integrated Security=True;"
commandText="INSERT INTO Logs(CreatedOn,Message,Level,Exception,StackTrace,Logger,Url) VALUES (@datetime,@msg,@level,@exception,@trace,@logger,@url)">
<parameter name="@datetime" layout="${date}" />
<parameter name="@msg" layout="${message}" />
<parameter name="@level" layout="${level}" />
<parameter name="@exception" layout="${exception}" />
<parameter name="@trace" layout="${stacktrace}" />
<parameter name="@logger" layout="${logger}" />
<parameter name="@url" layout="${aspnet-request-url}" />
</target>

还有这个规则:

<logger name="myAppLoggerRules" minlevel="Debug" writeTo="myAppLoggerTarget" />

由于某些原因，当我调用时，例如:GetLogger("myAppLoggerRules").Debug(message);，日志只保存到数据库，不保存到文件。

当我注释掉数据库目标时，文件目标工作正常…

Answer 1

我很确定每个目标都需要唯一的名称。所以你的代码应该是:

<target xsi:type="File" name="file" fileName="${basedir}/logs/${shortdate}.log"
layout="${longdate} ${uppercase:${level}} ${message}" />
<target xsi:type="Database"
name="database"
connectionString="Data Source=R5-4500USQLEXPRESS;Initial Catalog=BlogDb;Integrated Security=True;"
commandText="INSERT INTO Logs(CreatedOn,Message,Level,Exception,StackTrace,Logger,Url) VALUES (@datetime,@msg,@level,@exception,@trace,@logger,@url)">
<parameter name="@datetime" layout="${date}" />
<parameter name="@msg" layout="${message}" />
<parameter name="@level" layout="${level}" />
<parameter name="@exception" layout="${exception}" />
<parameter name="@trace" layout="${stacktrace}" />
<parameter name="@logger" layout="${logger}" />
<parameter name="@url" layout="${aspnet-request-url}" />
</target>
...
<logger name="myAppLoggerRules" minlevel="Debug" writeTo="file" />
<logger name="myAppLoggerRules" minlevel="Debug" writeTo="database" />