Tracing - Write Log Messages to Database

Hi Dennis,
you are right about the fact the i can plugin my own Listener. The Problem here is with the Listener all i get is a plain text line. I created a BO now to store my Logging Events, all works perfect currently. But within the TraceListener i currently dont know if the Message is an "Info" Message, an "Error" Message or whatever…?

Hi Noxe,
At present, there's no built-in capability to accomplish this task, I'm afraid. We've registered a corresponding suggestion at: Tracing - Introduce the capability to manually save each entry of the Tracing class with the {Information, Warning, Error} status and context information (for ASP.NET applications). We'll keep you informed on our progress.
Thanks,
Alex

Log4Net helpful?

From http://www.codeproject.com/Articles/140911/log4net-Tutorial the following snippet:

XML
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">  
 <bufferSize value="100" />  
 <connectionType value="System.Data.SqlClient.SqlConnection,  
 System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />  
 <connectionString value="data source=[database server];  
 initial catalog=[database name];integrated security=false;  
 persist security info=True;User ID=[user];Password=[password]" />  
 <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],  
 [Message],[Exception]) VALUES (@log_date, @thread, @log_level,  
 @logger, @message, @exception)" />  
 <parameter>  
 <parameterName value="@log_date" />  
 <dbType value="DateTime" />  
 <layout type="log4net.Layout.RawTimeStampLayout" />  
 </parameter>  
 <parameter>  
 <parameterName value="@thread" />  
 <dbType value="String" />  
 <size value="255" />  
 <layout type="log4net.Layout.PatternLayout">  
 <conversionPattern value="%thread" />  
 </layout>  
 </parameter>  
 <parameter>  
 <parameterName value="@log_level" />  
 <dbType value="String" />  
 <size value="50" />  
 <layout type="log4net.Layout.PatternLayout">  
 <conversionPattern value="%level" />  
 </layout>  
 </parameter>  
 <parameter>  
 <parameterName value="@logger" />  
 <dbType value="String" />  
 <size value="255" />  
 <layout type="log4net.Layout.PatternLayout">  
 <conversionPattern value="%logger" />  
 </layout>  
 </parameter>  
 <parameter>  
 <parameterName value="@message" />  
 <dbType value="String" />  
 <size value="4000" />  
 <layout type="log4net.Layout.PatternLayout">  
 <conversionPattern value="%message" />  
 </layout>  
 </parameter>  
 <parameter>  
 <parameterName value="@exception" />  
 <dbType value="String" />  
 <size value="2000" />  
 <layout type="log4net.Layout.ExceptionLayout" />  
 </parameter>  
</appender>  

FYI… As far as I am aware log4net does not currently support .Net Framework 4.5

C#
namespace App.Win  
{  
    using System;  

    using log4net;  
    using log4net.Appender;  
    using log4net.Config;  
    using log4net.Layout;  
    using log4net.Repository;  
    using log4net.Repository.Hierarchy;  

    public sealed class LoggingConfig  
    {  
        public static bool ConfigureLog4Net(string applicationPath, string connectionString, string loggingConfigFile)  
        {  
            if (!isLog4NetConfigured())  
            {  
                // Read an external log4net Config File for the configuration options  
                string configFileName = System.IO.Path.Combine(applicationPath, loggingConfigFile);  
                if (!System.IO.File.Exists(configFileName))  
                {  
                    configFileName = System.IO.Path.Combine(applicationPath, Constants.DefaultLoggingConfigFile);  
                }  

                if (System.IO.File.Exists(configFileName))  
                {  
                    XmlConfigurator.ConfigureAndWatch(new System.IO.FileInfo(configFileName));  
                    if (!string.IsNullOrEmpty(connectionString))  
                    {  
                        SetAdoNetAppenderConnectionStrings(connectionString);  
                    }  
                }  

                if (!isLog4NetConfigured())  
                {  
                    // Read the Application's Config File for the log4net configuration options  
                    XmlConfigurator.Configure();  
                    if (!string.IsNullOrEmpty(connectionString))  
                    {  
                        SetAdoNetAppenderConnectionStrings(connectionString);  
                    }  
                    if (!isLog4NetConfigured())  
                    {  
                        // Use default configuration options  
                        GetDefaultConfiguration(Constants.DefaultLogFileName);  
                    }  
                }  
            }  

            return isLog4NetConfigured();  
        }  

        /// <summary>  
        /// Is log4net configured  
        /// </summary>  
        /// <returns>Boolean</returns>  
        public static bool isLog4NetConfigured()  
        {  
            return LogManager.GetRepository().Configured;  
        } // isLog4NetConfigured()  

        private static void GetDefaultConfiguration(string logFileName)  
        {  
            PatternLayout patternLayout = new PatternLayout(Constants.DefaultLogPattern);  

            FileAppender fileAppender = new FileAppender { File = System.IO.Path.GetTempPath() + logFileName, Layout = patternLayout };  
            fileAppender.ActivateOptions();  

            BasicConfigurator.Configure(LogManager.GetRepository(), fileAppender);  
        }  

        private static void SetAdoNetAppenderConnectionStrings(string connectionString)  
        {  
            ILoggerRepository hierarchy = (Hierarchy)LogManager.GetRepository();  
            if (hierarchy != null)  
            {  
                IAppender[] appenders = hierarchy.GetAppenders();  

                foreach (IAppender appender in appenders)  
                {  
                    if (appender is AdoNetAppender)  
                    {  
                        AdoNetAppender adoNetAppender = (AdoNetAppender)appender;  
                        adoNetAppender.ConnectionString = connectionString;  
                        adoNetAppender.ActivateOptions();  
                    }  
                }  
            }  
        }  

        private LoggingConfig()  
        {  
        }  
    }  
}  

Add this class to your project

then in some appropriate spot in your app startup

C#
string connectionString = GetConnectionString("ConnectionStringName");  
LoggingConfig.ConfigureLog4Net(AppDomain.CurrentDomain.BaseDirectory, connectionString);  

Then go nuts with Log4Net.

Don't forget the config