title: Log4Net with AdoAppender but nothing in SQL
body: <p>I try to log error messages using log4net and save them into database using SQL, but nothing happens at all.... Did I miss something? Here is my code</p>
  
  <pre><code>            Hierarchy hierarchy = (Hierarchy)LogManager.GetRepository();
              hierarchy.Root.RemoveAllAppenders(); /*Remove any other appenders*/
              log4net.Repository.Hierarchy.Logger rootLogger = hierarchy.Root;
              rootLogger.Level = hierarchy.LevelMap["ERROR"];
  
  
              AdoNetAppender ado = new AdoNetAppender();
              ado.ConnectionType = "System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089";
              ado.ConnectionString = ConfigurationManager.AppSettings["MSSQLConnectionString_nvn1"];
              ado.CommandText = "INSERT INTO Log ([Date],[Thread],[Level],[Identity],[Username],[Logger],[Message]) VALUES (@log_date, @thread , @level , @identity , @username ,  @logger, @message)";
              ado.BufferSize = 1;
              ado.Threshold = log4net.Core.Level.Error;
  
              AdoNetAppenderParameter logd = new AdoNetAppenderParameter();
              logd.ParameterName = "@log_date";
              logd.DbType = DbType.DateTime;
              logd.Layout = new log4net.Layout.RawTimeStampLayout();
              ado.AddParameter(logd);
  
                  ...........
  
              ado.ActivateOptions();
              log4net.Config.BasicConfigurator.Configure(ado);
  </code></pre>
  
  <p>Thanks. </p>
  
  <p>Summary: Could anyone please check my codes and try to give me some advices about how to save error messages from log4net into a database.</p>