DataObjects.Net 5.0 meets NLog & log4net

In the previous post we explained DataObjects.Net built-in logging capabilities. Now it is time to show how popular logging libraries like log4net and NLog can be integrated with it.

We would need the list of names of built-in logs:

Xtensive.Orm - logs Session & Transaction-related events and exceptions.

Xtensive.Orm.Building - logs events during the Domain building process.

Xtensive.Orm.Sql - logs SQL statements sent to database server.

Xtensive.Orm.Upgrade - logs events during database schema upgrade.

log4net

1. Add DataObjects.Net logging provider for log4net. It will automatically add log4net.
2. Set up log provider in Xtensive.Orm configuration section
   
   

    <Xtensive.Orm>
      <domains>
        <domain ... >
        </domain>
      </domains>
      <logging provider="Xtensive.Orm.Logging.log4net.LogProvider, Xtensive.Orm.Logging.log4net">
    </Xtensive.Orm>
   

3. Configure log4net. Use the above-mentioned loggers' names, e.g.:
   
   

    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
      <configSections>
        ...
        <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>
      </configSections>
    
      <log4net>
        <appender name="ConsoleAppernder" type="log4net.Appender.ConsoleAppender">
          <layout type="log4net.Layout.PatternLayout">
            <conversionPattern value="%date [%thread] %-5level %logger %message%newline" />
          </layout>
        </appender>
      
        <logger name="Xtensive.Orm">
          <level value="ALL" />
          <appender-ref ref="ConsoleAppernder" />
        </logger>
      </log4net>
    </configuration>
   
   

NLog

1. Add DataObjects.Net logging provider for NLog. It will automatically add NLog.
2. Set up log provider in Xtensive.Orm configuration section
   
   

    <Xtensive.Orm>
      <domains>
        <domain ... >
        </domain>
      </domains>
      <logging provider="Xtensive.Orm.Logging.NLog.LogProvider, Xtensive.Orm.Logging.NLog">
    </Xtensive.Orm>
   

3. Configure NLog. Use the above-mentioned loggers' names, e.g.:
   
   

       <?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">
   
         <targets>
           <target name="console" xsi:type="Console" />
         </targets>
   
         <rules>
           <logger name="Xtensive.Orm" minlevel="Debug" writeTo="console" />
         </rules>
       </nlog>
   

Pretty simple, huh? You can even write your own log provider with ease. Just take a look at the implementation of these two in DataObjects.Net Extensions repository, default branch.