log4net AdoNetAppender in .Net core not supported?

2.7k Views Asked by At

I'm trying to implement log4net 2.0.8 in our dot net core 1.1.2 app. The ConsoleAppender is working fine, but the AdoNetAppender throws an error:

Could not load type 'log4net.Appender.AdoNetAppender'

Is AdoNetAppender still not supported in Dot Net Core?

My config:

<?xml version="1.0" encoding="utf-8" ?>
<log4net debug="true">
  <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
    <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%date{ABSOLUTE} [%thread] %-5level %logger: %message%newline" />
    </layout>
  </appender>
  <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
    <bufferSize value="1" />
    <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <connectionString value="data source=MyMSSQLServer; initial catalog=MyDatabase;integrated security=false;persist security info=True;User ID=sa;Password=***" />
    <commandText value="dbo.prcLog4Net_LogMsg" />
    <commandType value="StoredProcedure" />
    <parameter>
      <parameterName value="@session_id" />
      <dbType value="Int" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%property{session_id}" />
      </layout>
    </parameter>
    <parameter>
      <parameterName value="@message" />
      <dbType value="AnsiString" />
      <size value="4000" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%message" />
      </layout>
    </parameter>
  </appender>
  <root>
    <level value="DEBUG" />
    <appender-ref ref="ConsoleAppender" />
    <appender-ref ref="AdoNetAppender" />
  </root>
</log4net>
1

There are 1 best solutions below

0
Peter On BEST ANSWER

The ado.net appender is not supported, you can look it up in the following page: framework-support.html#Appenders