You could have also copied the built-in TimeStamp layout
// log4net.Layout
public class RawTimeStampLayout : IRawLayout
{
public object Format(LoggingEvent loggingEvent)
{
return loggingEvent.TimeStamp;
}
}
and made your own Level layout:
public class RawLevelLayout : IRawLayout
{
public object Format(LoggingEvent loggingEvent)
{
return loggingEvent.Level;
}
}
----- Original Message ----
From: James Green <[email protected]>
To: Log4NET User <[email protected]>
Sent: Tuesday, June 16, 2009 5:58:12 AM
Subject: RE: Using AdoNetAppender
Cracked it ...
AdoNetAppenderParameter logLevel = new
AdoNetAppenderParameter();
logLevel.ParameterName = "@log_level";
logLevel.Layout = new Layout2RawLayoutAdapter(new
PatternLayout("%level"));
logLevel.Size = 50;
logLevel.DbType = System.Data.DbType.String;
_sqlDatabaseAppender.AddParameter(logLevel);
Regards,
James.
