
<p>
  This blog will show a example of how to config NLog so able to log to file,
  database and call class.
</p>
<p>Example requirement for Logging :&nbsp;</p>
<ul>
  <li>Debug, Info, Warning, Error, Fatal level log to file</li>
  <li>Info, Warning, Error, Fatal log to database</li>
  <li>Fata log send email.</li>
</ul>
<h3>1. Install NLog via Nuget</h3>
<p>
  Type following at visual studio Package Manager Console window.
  <code>Install-Package NLog</code>
</p>
<h3>2. Add <code>NLog.config</code> file</h3>
<pre
  class="language-javascript"
><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;

  &lt;!-- 
  See http://nlog-project.org/wiki/Configuration_file 
  for information on customizing logging rules and outputs.
   --&gt;
  &lt;variable name="logDir" value="${specialfolder:folder=ApplicationData}/Log/"&gt;&lt;/variable&gt;
  &lt;variable name="logFormat" value="${longdate} ${callsite} ${level} ${stacktrace} ${message}"&gt;&lt;/variable&gt;
  &lt;targets&gt;
    &lt;target xsi:type="File" name="file" fileName="${logDir}/${shortdate}.log" layout="${longdate} ${uppercase:${level}} ${message} ${exception:format=tostring}" maxArchiveFiles="1" archiveAboveSize="1000000"/&gt;
    &lt;target name="database" type="Database"&gt; 
      &lt;connectionString&gt; 
        Data Source=databaseservername;Initial Catalog=databasename;User Id=username;Password=password; 
      &lt;/connectionString&gt; 
      &lt;commandText&gt; 
        insert into YourTableForLogging(date,level,message,machine_name, user_name, call_site,thread, exception, stacktrace) values(@time_stamp, @level, @message,@machinename, @user_name, @call_site, @threadid, @log_exception, @stacktrace); 
      &lt;/commandText&gt; 
      &lt;parameter name="@time_stamp" layout="${longdate}"/&gt; 
      &lt;parameter name="@level" layout="${level}"/&gt; 
      &lt;parameter name="@message" layout="${message}"/&gt; 
      &lt;parameter name="@machinename" layout="${machinename}"/&gt; 
      &lt;parameter name="@user_name" layout="${windows-identity:domain=true}"/&gt; 
      &lt;parameter name="@call_site" layout="${callsite:filename=true}"/&gt;
      &lt;parameter name="@threadid" layout="${threadid}"/&gt; 
      &lt;parameter name="@log_exception" layout="${exception}"/&gt; 
      &lt;parameter name="@stacktrace" layout="${exception:stacktrace}"/&gt;
    &lt;/target&gt;
	 &lt;target name="sendEmail" xsi:type="MethodCall" className="yourClassForSendingEmalNamespace, thisClassAssemblyName" methodName="MethodToSendEmail"&gt;
		&lt;parameter layout="${level}" /&gt;
		 &lt;parameter layout="${message}" /&gt;
		 &lt;parameter layout="${machinename}" /&gt;
		 &lt;parameter layout="${exception}" /&gt;
		 &lt;parameter name="stacktrace" layout="${exception:format=tostring}" /&gt;
	&lt;/target&gt;
  &lt;/targets&gt;

  &lt;rules&gt;
    &lt;!-- add your logging rules here --&gt;
&lt;logger name="*" minlevel="Debug" writeTo="file" /&gt;
&lt;logger name="*" minlevel="Info" appendTo="database"/&gt; 
&lt;logger name="*" minlevel="Fatal" writeTo="sendEmail" /&gt;

  &lt;/rules&gt;
&lt;/nlog&gt;
</code></pre>
<h3>
  At this point, NLog config setting is ready you should be able to use NLog at
  code.
</h3>
<p>
  For how to call NLog, you could either reference following article to write
  code to the .NET and, NLog should be automatically, if you're log as Fatal
  level, will call specific class to do thing.
</p>
<p>
  <a href="https://github.com/nlog/nlog/wiki/Tutorial" target="_blank"
    >How to call NLog</a
  >
</p>


This blog will show a example of how to config NLog so able to log to file, database and call class.

Category NLog

How to Config NLog to Log to File, Database and Send Email