Nlog 记录数据库到Oracle

1、安装

image.png

2、配置文件nlog.config

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      autoReload="true"
      throwConfigExceptions="true"
      internalLogLevel="None"
      internalLogFile="Log\internal-nlog.txt">
  <targets>
    <!-- 【固定大小分页】target添加属性： archiveNumbering="Sequence" archiveAboveSize="104857600"-->
    <target xsi:type="File" name="all" fileName="Log/${shortdate}/ALL.log"  
             layout="${longdate}|${logger}|${uppercase:${level}}|${message} ${exception}" />
    <target xsi:type="File" name="info" fileName="Log/${shortdate}/Info.log"
             layout="${longdate}|${logger}|${uppercase:${level}}|${message} ${exception}" />
    <target xsi:type="File" name="error" fileName="Log/${shortdate}/Error.log"
             layout="${longdate}|${logger}|${uppercase:${level}}|${message} ${exception}" />
    <target xsi:type="Database" dbProvider="Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess" name="database" connectionstring="Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.8.211)(PORT = 1522))(CONNECT_DATA = (SERVICE_NAME = xxx))); User Id = xxxx; Password=xxx;Connection Timeout=500;">
      <commandText>
        insert into FWATIOLog(MESSAGE) values (:message)
      </commandText>
      <parameter name=":message" layout="1"/>
    </target>
  </targets>
  <rules>
    <logger name="*" minlevel="Info" writeTo="all" />
    <logger name="*" minlevel="Info" writeTo="database"/>
    <logger name="Microsoft.*" minlevel="Trace"  final="true" />
    <logger name="*" level="Info" writeTo="info" final="true" />
    <logger name="*" level="Error" writeTo="error" final="true" />
  </rules>
</nlog>