Log4Net, how to add a custom field to my logging

by

1) Modify the command text: INSERT INTO Log4Net ([Date],[Thread],[Level],[Logger],[Message],[Exception],[MyColumn]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception, @CustomColumn)

2) Add the parameter definition for the custom column:

<parameter>
   <parameterName value="@CustomColumn"/>
   <dbType value="String" />
   <size value="255" />
   <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%property{CustomColumn}" />
  </layout>
</parameter>

3) Then use one of log4net’s contexts to transfer values to the parameter:

// thread properties...
log4net.LogicalThreadContext.Properties["CustomColumn"] = "Custom value";
log.Info("Message"); 

// ...or global properties
log4net.GlobalContext.Properties["CustomColumn"] = "Custom value";

More Related Contents:

  1. How can I change the file location programmatically?
  2. Log4Net: Programmatically specify multiple loggers (with multiple file appenders)
  3. Log4net rolling daily filename with date in the file name
  4. Can you configure log4net in code instead of using a config file?
  5. app.config for a class library
  6. Capture username with log4net
  7. Best way to dynamically set an appender file path
  8. Log4Net Logging of two different levels to two different appenders for the same logger
  9. How I can set log4net to log my files into different folders each day?
  10. MoveNext instead of actual method/task name
  11. How to disable creation of empty log file on app start?
  12. Why do loggers recommend using a logger per class?
  13. How do you log the machine name via log4net?
  14. How to use Property Injection with AutoFac?
  15. How to log stack trace using log4net (C#)
  16. Enable file logging for log4net from code instead of from configuration
  17. How to log Trace messages with log4net?
  18. log4net: Configure to ignore messages from a specific class
  19. Logging to an individual log file for each individual thread
  20. how to convert my decimal thread ID to hex and make it appear in hex format in log4net conversion pattern?
  21. Change default app.config at runtime
  22. Should functions return null or an empty object?
  23. How can I extract a file from an embedded resource and save it to disk?
  24. Can a unit test project load the target application’s app.config file?
  25. What do programmers mean when they say, “Code against an interface, not an object.”?
  26. linq group by contiguous blocks
  27. Reading an int that’s updated by Interlocked on other threads
  28. Can I have a variable number of generic parameters?
  29. Fluent NHibernate, working with interfaces
  30. Setting a proxy for Chrome Driver in Selenium

Leave a Comment