nlog.config

<?xml version="1.0" encoding="utf-8" ?>
<nlog internalLogFile="C:/DemoApi.txt" internalLogLevel="Error" throwExceptions="true" xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <extensions>
    <add assembly="NLog.Web.AspNetCore"/>
  </extensions>
  
  <targets async="false">
    <target xsi:type="FallbackGroup" name="LogDb" returnToFirstOnSuccess="true">
      <target name="LogDatabase" xsi:type="Database" connectionString="${gdc:item=connectionString}" commandType="StoredProcedure" commandText="[dbo].[EventCreate]">
        <parameter name="@Level" layout="${level}" />
        <parameter name="@Source" layout="${literal:text=Demo Api}" />
        <parameter name="@Type" layout="${literal:text=Logger}" />
        <parameter name="@Message" layout="${message}" />     
        <parameter name="@Timestamp" layout="${date:format=yyyy-MM-ddTHH\:mm\:ss.fffzzz}" />
        <parameter name="@User" layout="${when:when=length('${gdc:item=user}') &gt; 0:inner=${gdc:item=user}:else=?}" /> 
        <parameter name="@Data" layout="${all-event-properties}" />
      </target>
     
    </target>
  </targets>
  <rules>
    <logger name="*" minlevel="Info" writeTo="LogDb" />
  </rules>
</nlog>