using System;
using System.Collections.Generic;
using System.Text;

using log4net.Config;
using log4net.Core;
using log4net.Repository.Hierarchy;
using log4net.Appender;
  
using System.Net;
using System.Data.Sql;
using System.Data.SqlTypes;
using Microsoft.SqlServer;
using Microsoft.SqlServer.Server;


//[assembly: log4net.Config.XmlConfigurator(Watch = false)]
//[assembly: log4net.Config.XmlConfigurator(ConfigFile = "clrtest.config", Watch = true)] 

namespace CLRTEST
{
    public class CLRTESTCLASS
    {

        private static readonly log4net.ILog log = log4net.LogManager.GetLogger(typeof(CLRTESTCLASS));

        [SqlProcedure()]
        public static void ported_numbers(String url, String originalNumber, String tempNumber, DateTime portDate)
        {

            log4net.Config.XmlConfigurator.Configure(new System.IO.FileInfo("clrtest.config"));
            
            String message = "TEST MESSAGE";

            log.Info(message);

  <log4net>
    <!-- Define some output appenders -->
    <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
      <file value="CLRTEST.log"/>
      <appendToFile value="true"/>
      <encoding value="utf-8"/>
      <maxSizeRollBackups value="1000"/>
      <maximumFileSize value="10000"/>
      <rollingStyle value="Composite"/>
      <datePattern value="yyyyMMdd"/>
      <staticLogFileName value="false"/>
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%thread] %-5level %logger [%ndc] - %message%newline"/>
      </layout>
    </appender>
    <!-- Setup the root category, add the appenders and set the default level -->
    <root>
      <level value="ALL"/>
      <appender-ref ref="RollingLogFileAppender"/>
      <!-- <appender-ref ref="A"/> -->
    </root>
    <!-- Specify the level for some specific categories -->
  </log4net>
  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v3.5" sku=".NETFramework,Version=v3.5"/>
  </startup>
</configuration>