Re: Using AdoNetAppender

[Ron Grabowski]

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 <james.gr...@occam-dm.com>
To: Log4NET User <log4net-user@logging.apache.org>
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.