Custom Logging with Personal Fields in Nlog


Setting the database string via
var databaseTarget = (DatabaseTarget)LogManager.Configuration.FindTargetByName("database");
databaseTarget.ConnectionString = connectionString;
LogManager.ReconfigExistingLoggers();
The above didn't work but I used the example below where I set it via the program's start.

var defaultConnection = Configuration.GetConnectionString("DefaultConnection");
NLog.GlobalDiagnosticsContext.Set("defaultConnection", defaultConnection);
var logger = LogManager.LoadConfiguration("nlog.config").GetCurrentClassLogger();
Then you can use ${gdc:item=defaultConnection} in your nlog.config:
<target xsi:type="Database" connectionString="${gdc:item=defaultConnection}" />
Rather than using GDC, which is for global static data and fails on concurrent logging, it is better to use EventProperties-Layout-Renderer which allows to pass of custom  properties specific to the event

The easiest way of overriding connection string is through the use of GDC:
<target name="db" type="Database" connectionString="${gdc:myConnectionstring}" ... />
Now in your code you can simply do:
GDC.Set("myConnectionString", "Server=.;database=.....");
For Custom Logging with the following...
LogEventInfo theEvent = new LogEventInfo(logLevel, "", message);
theEvent.Properties["OrderId"] =orderId;`

log.Log(theEvent);

... and in your NLog.config file: 
${event-context:item=OrderId}  -- obsolete
${event-properties:item=OrderId} -- renders OrderId
https://github.com/nlog/NLog/wiki/Database-target
<nlog throwExceptions="true" xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <targets>
      <target name="default" xsi:type="File" fileName="logs/app-log.txt" archiveFileName="logs/archives/app-log.{#}.txt" archiveEvery="Day" archiveNumbering="Rolling" maxArchiveFiles="7" />
      <target name="database" xsi:type="Database" dbProvider="System.Data.SqlClient"
        commandText="INSERT INTO [dbo].[AppLog] 
        ([database_name],[app_name], [version], [message_type], [message], [routine], [src_file], [src_line], [username], [computer_name])                   VALUES                                       ('300', @app_name, @version, @message_type,  @message, @routine , @src_file, @src_line, @username, @computer_name)">
        <parameter name="@app_name" layout="${processname}" />
        <parameter name="@version" layout="${assembly-version}" />
        <parameter name="@message_type" layout="${level}" />
        <parameter name="@message" layout="${message}" />
        <parameter name="@routine" layout="${callsite:className=true:includeSourcePath=true:methodName=true}" />
        <parameter name="@src_file" layout="${currentdir}" />
        <parameter name="@src_line" layout="${callsite-linenumber}" />
        <parameter name="@username" layout="${environment-user}" />
        <parameter name="@computer_name" layout="${machinename}" />
      </target>
    </targets>
    <rules>
      <logger name="*" writeTo="database" />
    </rules>
  </nlog>
Doing the rest...
  1.         <target name="eventlog" xsi:type="EventLog" layout="${message}" log="Application" source=" My Custom Api Services" />  
  2.         <target name="database" type="Database" connectionString="Data Source=your sql source;initial catalog=YourDbNameDb;user id=u1;password=p1;MultipleActiveResultSets=True;">  
  3. <rules>  
  4.         <!-- I am adding my 3 logging rules here -->  
  5.         <logger name="*" minlevel="Debug" writeTo="database" />  
  6.         <logger name="*" minlevel="Trace" writeTo="logfile" />  
  7.         <logger name="*" minlevel="Trace" writeTo="eventlog" />  
  8.     </rules>  

Popular posts from this blog

UI-Bootstrap Collapsible Sticky Footer

    I could have done this a lot of ways and ultimately I made it work with javascript modifying the class names. I also had to create multiple class names which I didn't like to much, I might come back and improve this but for now this is was I got. Also I call bootstrap+angularjs = ui-bootstrap, not sure if that's common sense but thought I should include it somewhere in my notes. Working Example: http://plnkr.co/edit/2N9ENlbw3bSvg1W9n0ch?p=preview This little css was key to prevent any kind of animation on the collapse, which would result in a scrollbar appearing on the body. A scrollbar can appear when the content's too long but not on the sticky foot duh! .no-animate { transition-duration: 0.0125s; } Research Angular-UI Bootstrap Collapse without animation - Stack Overflow http://jsfiddle.net/paulalexandru/Z2Lu5/  - Was looking at this to see if I could reuse it but I ended but just doing my own thing. Another way which I've seen Using a sticky
Read more

Installing Windows on Acer chromebook 15 cb3-532

Much of my notes are just small problems I faced (what's new!) haha. Either way this was a really fun project to do for a friend and I got excited once I research all the information. You can find instruction videos but what helped me the most was the coolstar website. Sadly they don't have parameters in the url so I can link the machine I used in this article. -  https://coolstar.org/chromebook/windows-install.html Scared of messing with the bios? Don't be!    So you need to first remove the screw to put a legacy bios on the machine. Its easy to backup the chrome os one and with the same steps to change it. You can go back in and revert to the chrome version bios. Its that last part that had me worried and its very easy to do.  Problems getting into Developer Mode?   Follow the instructions to the letter, during the step to disable the OS verification, press Ctrl-D to boot into os. If you hear two beeps I would go back to set one. I got in a loop where it s
Read more

Aspetcore: NLog with Postgresql

This Article is base ASP.Net Core 2 and the latest version of Nlog. 1. Install NLog and the Postgresql Package Using NuGet to install the package into your ASP.NET Core project: PM > Install-Package NLog.Web.AspNetCore PM > Install-Package Npgsql 3. Register NLog Add in your Startup.cs  public void Configure ( IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory ) { ... env.ConfigureNLog( "nlog.config" ); ... // make sure Chinese chars don't fk up Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); //add NLog to ASP.NET Core loggerFactory.AddNLog(); //add NLog.Web app.AddNLogWeb(); } 4. Add to Your Controller Add a logger object to your Controller. private readonly ILogger<YourController> _logger; Modify the constructor to use it public YourController ( ILogger<YourController> logger = null ) { if ( null != logger) { _logger = logger;
Read more