cvs commit: logging-log4net/src/Appender AdoNetAppender.cs

[nicko]

nicko       2005/05/03 03:48:13

  Modified:    src/Appender AdoNetAppender.cs
  Log:
  Fix for LOG4NET-28. AdoNetAppender does not support inserting NULL into 
columns
  
  Revision  Changes    Path
  1.13      +10 -1     logging-log4net/src/Appender/AdoNetAppender.cs
  
  Index: AdoNetAppender.cs
  ===================================================================
  RCS file: /home/cvs/logging-log4net/src/Appender/AdoNetAppender.cs,v
  retrieving revision 1.12
  retrieving revision 1.13
  diff -u -r1.12 -r1.13
  --- AdoNetAppender.cs 28 Jan 2005 22:18:26 -0000      1.12
  +++ AdoNetAppender.cs 3 May 2005 10:48:13 -0000       1.13
  @@ -1059,7 +1059,16 @@
                        // Lookup the parameter
                        IDbDataParameter param = 
(IDbDataParameter)command.Parameters[m_parameterName];
   
  -                     param.Value = Layout.Format(loggingEvent);
  +                     // Format the value
  +                     object formattedValue = Layout.Format(loggingEvent);
  +
  +                     // If the value is null then convert to a DBNull
  +                     if (formattedValue == null)
  +                     {
  +                             formattedValue = DBNull.Value;
  +                     }
  +
  +                     param.Value = formattedValue;
                }
   
                #endregion // Public Instance Methods