DEMOMySql/MicroServices/Procurement/Procurement.Host/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">
  <targets>
    <target xsi:type="Null" name="blackhole" />
    <target name="loginfo" xsi:type="File" fileName="logs/${shortdate}.log" />
    
    <target name="db"
                  xsi:type="Database"
                  connectionString="${var:NLOG_CONNECTION_STRING}"
                  commandType="StoredProcedure"
                  commandText="[dbo].[pr_SFM_SaveWebApiLog]">
      <parameter name="@traceId" layout="${aspnet-TraceIdentifier}" />
      <parameter name="@eventId" layout="${event-properties:EventId}" />
      <parameter name="@type" layout="${event-context:item=Type}" />
      <parameter name="@action" layout="${event-context:item=Action}" />
      <parameter name="@application" layout="Procurement" />
      <parameter name="@level" layout="${level}" />
      <parameter name="@category" layout="${logger}" />
      <parameter name="@message" layout="${message}" />
      <parameter name="@properties" layout="${all-event-properties:separator=|}" />
      <parameter name="@exception" layout="${exception:tostring}" />
      <parameter name="@clientIP" layout="${aspnet-request-ip}" />
    </target>
  </targets>

  <rules>
    <logger name="Microsoft.EntityFrameworkCore.Infrastructure" minlevel="Info" writeTo="blackhole" final="true" />
    <logger name="Procurement.Core.NLogHelper" minlevel="Info" writeTo="db"/>
    <logger name="*" minlevel="Info" writeTo="loginfo" />
  </rules>
</nlog>