log4net.config file Either for the Database or for File Level

See more:

C#

ASP.NET

SQL-Server

, +

Hi Friends,

I have developed the code to log the defacts in the database as well as in the file.using the log4net configuration file.

The problem i have is how to make it configurable means either on the database level or on the file level.and how to decide at a time log the defacts in the database or in file with out changing the log4net configuration

I have placed the appender

<appender name="AdoNetAppender_SqlServer" type="log4net.Appender.AdoNetAppender">

and appender referance as

<pre> <appender-ref ref="AdoNetAppender_SqlServer" />

and my logger class constructor is

public Logger()
       {

         FileInfo log4netConfig = new FileInfo(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);

           Configure(log4netConfig.Directory + "\\log4net.config");//////line 1
           log4net.Config.XmlConfigurator.Configure();/////////////line 2
           Log = LogManager.GetLogger("root");
       }

Can we manage the database or the file setting in this constructor??

Please Help me
Thanks in advance