useful log4net settings

Database hit logging

• Console log of everything including and above WARN
• File log all db queries to logs/dbhits.txt (replace file every startup)

<log4net>
    <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
      <filter type="log4net.Filter.LevelRangeFilter">
        <acceptOnMatch value="true" />
        <levelMin value="INFO" />
        <levelMax value="FATAL" />
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%thread] %-5level %logger - %message%newline" />
      </layout>
    </appender>
    
    <appender name="dbhitfileappender" type="log4net.Appender.FileAppender">
      <file value="logs/dbhits.log"/>
      <lockingModel type="log4net.Appender.FileAppender+MinimalLock"/>
      <appendToFile value="false" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%message | %date%newline" />
      </layout>
      <filter type="log4net.Filter.LoggerMatchFilter">
        <acceptOnMatch value="true" />
        <LoggerToMatch value="MindTouch.Deki.Data.LoggingDekiDataSession" />   
      </filter>
      <filter type="log4net.Filter.DenyAllFilter" />
    </appender>
    <renderer renderingClass="MindTouch.Logging.ExceptionRenderer" renderedClass="System.Exception" />
    <!-- Set root logger level to DEBUG and its only appender to A1 -->
    <root>
      <level value="TRACE" />
      <appender-ref ref="ConsoleAppender" />
      <appender-ref ref="dbhitfileappender" />
    </root>
  </log4net>