NLogUserIdToDB

NLog.Config

  <targets>
    <target name="dbLogger" xsi:type="Database"
            connectionStringName="DefaultConnection" commandText="
          insert into dbo.Log (
          Date, Level, Message, Username,
          ServerName, SessionId
          ) values (
          @Date, @Level, @Message,
          @Username, @ServerName, @SessionId
          );">
      <parameter layout="${Level}" name="@Level"/>
      <parameter name="@username" layout="${identity}" />
      <parameter name="@Date" layout="${date}" />
      <parameter name="@Message" layout="${message}" />
      <parameter name="@serverName" layout="${aspnet-request:serverVariable=SERVER_NAME}" />
      <parameter name="@SessionId" layout="${aspnet-sessionid}" />
      <!-- repeated -->
    </target>
    <!--
    add your targets here
    See https://github.com/nlog/NLog/wiki/Targets for possible targets.
    See https://github.com/nlog/NLog/wiki/Layout-Renderers for the possible layout renderers.
    -->

    <!--
    Write events to a file with the date in the filename.
    <target xsi:type="File" name="f" fileName="${basedir}/logs/${shortdate}.log"
            layout="${longdate} ${uppercase:${level}} ${message}" />
    -->
  </targets>