没有使用NLog 3.1和温莎城堡日志设施的目标数据库

Question

我可以使用NLog登录到一个文件，但是数据库不是创建的，如果我手动创建它，就不会记录任何内容。

我可能遗漏了什么东西吗？

这是我的NLog.config

<?xml version="1.0" encoding="utf-8" ?>

​

<target name="database" xsi:type="Database">
  <connectionString>
    Server=.\SQLEXPRESS; Database=Logging; User Id=user; Password=password;
  </connectionString>
  <commandText>
    insert into LogEntries(Date,Level,Logger,Message,MachineName, UserName, Callsite, ThreadId, Exception, InnerException, Stacktrace, ErrorSource, ErrorClass, ErrorMethod, ErrorMessage, InnerErrorMessage) values(@time_stamp, @level, @logger, @message,@machinename, @user_name, @call_site, @threadid, @log_exception, @log_innerexception, @stacktrace, @ErrorSource, @ErrorClass, @ErrorMethod, @ErrorMessage, @InnerErrorMessage);
  </commandText>
  <parameter name="@time_stamp" layout="${longdate}"/>
  <parameter name="@level" layout="${level:uppercase=true}"/>
  <parameter name="@logger" layout="${logger}"/>
  <parameter name="@message" layout="${message}"/>
  <parameter name="@machinename" layout="${machinename}"/>
  <parameter name="@user_name" layout="${windows-identity:domain=true}"/>
  <parameter name="@call_site" layout="${callsite:filename=true}"/>
  <parameter name="@threadid" layout="${threadid}"/>
  <parameter name="@ErrorSource" layout="${event-context:item=error-source}" />
  <parameter name="@ErrorClass" layout="${event-context:item=error-class}" />
  <parameter name="@ErrorMethod" layout="${event-context:item=error-method}" />
  <parameter name="@ErrorMessage" layout="${event-context:item=error-message}" />
  <parameter name="@InnerErrorMessage" layout="${event-context:item=inner-error-message}" />
  <parameter name="@log_exception" layout="${exception:format=type,message,method:maxInnerExceptionLevel=5:innerFormat=shortType,message,method}"/>
  <parameter name="@log_innerexception" layout="${exception:method:maxInnerExceptionLevel=5:innerFormat=shortType,message,method}"/>
  <parameter name="@stacktrace" layout="${stacktrace}"/>
  <dbProvider>System.Data.SqlClient</dbProvider>
  <install-command>
    <text>CREATE DATABASE Logging</text>
    <connectionString>Server=.\SQLEXPRESS; Database=master; User Id=user; Password=password;</connectionString>
    <ignoreFailures>true</ignoreFailures>
  </install-command>

  <install-command>
    <text>
      CREATE TABLE [dbo].[LogEntries](
      [Id] [int] IDENTITY(1,1) NOT NULL,
      [Level] [varchar](5) NOT NULL,
      [Message] [varchar](4095) NOT NULL,
      [Date] [datetime] NOT NULL,
      [Logger] [varchar](200) NULL,
      [MachineName] [varchar](100) NULL,
      [UserName] [varchar](100) NULL,
      [CallSite] [varchar](100) NULL,
      [ThreadId] [varchar](100) NULL,
      [Exception] [varchar](max) NULL,
      [InnerException] [varchar](max) NULL,
      [Stacktrace] [varchar](max) NULL,
      ErrorSource [varchar](max) NULL, 
      ErrorClass [varchar](max) NULL, 
      ErrorMethod [varchar](max) NULL, 
      ErrorMessage [varchar](max) NULL, 
      InnerErrorMessage [varchar](max) NULL,
      CONSTRAINT [PK_Logs] PRIMARY KEY CLUSTERED
      ([Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    </text>
  </install-command>

   <!--commands to uninstall database--> 
  <uninstall-command>
    <text>DROP DATABASE Logging</text>
    <connectionString>Server=.\SQLEXPRESS; Database=master; User Id=user; Password=user;</connectionString>
    <ignoreFailures>true</ignoreFailures>
  </uninstall-command>
</target>

​

Answer 1

如果Nlog有任何问题，通过将其添加到nlog.config的根元素来打开内部测井总是一个很好的起点：

<nlog internalLogFile="c:\log.txt" internalLogLevel="Trace">

在您的具体配置中，install-command不会自动运行，因为NLOG本身不会运行它们。

您需要使用一个名为InstallNLogConfig.exe的命令行工具，它通过调用运行这些命令：

InstallNLogConfig.exe c:\path\to\NLog.config

如果您已经在nuget中安装了NLog，则可以在

\packages\NLog.{version}\tools\{yourFrameworkVersion}\InstallNLogConfig.exe

您可以阅读更多关于这里：部署NLog配置文件的文章。