MySQL Appender not inserting data in database in Log4Net
<p>It doesn't show any errors anymore, but it also doesn't insert anything into the MySQL database. Any ideas? I replaced my login information with dummy text.</p>

<p><strong>Edit</strong></p>

<p>There is an error about the connection type.</p>

<pre><code>log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Failed to load connection type [MySql.Data.MySqlClient.MySqlConnection, MySql.Data, Version=5.5.47, Culture=neutral, PublicKeyToken=c5687fc88969c44d]
System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=5.5.47, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
File name: 'MySql.Data, Version=5.5.47, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)
   at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&amp; stackMark)
   at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
   at log4net.Util.SystemInfo.GetTypeFromString(Assembly relativeAssembly, String typeName, Boolean throwOnError, Boolean ignoreCase)
   at log4net.Util.SystemInfo.GetTypeFromString(String typeName, Boolean throwOnError, Boolean ignoreCase)
   at log4net.Appender.AdoNetAppender.ResolveConnectionType()
</code></pre>

<p><strong>This is my <code>App.config</code> file</strong></p>

<pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;configuration&gt;
  &lt;configSections&gt;
    &lt;section name="log4net" type="log4net.Config.log4NetConfigurationSectionHandler, log4net"/&gt;
  &lt;/configSections&gt;

  &lt;log4net&gt;
    &lt;!-- appenders here --&gt;

    &lt;appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"&gt;
      &lt;bufferSize value="1" /&gt;
      &lt;connectionType value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data, Version=5.5.47, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt;
      &lt;connectionString value="Server=myhost;Database=mydb;UID=myuser;Password=mypassword" /&gt;
      &lt;commandText value="INSERT INTO mylog (date) VALUES (?date)" /&gt;
      &lt;parameter&gt;
        &lt;parameterName value="date" /&gt;
        &lt;dbType value="DateTime" /&gt;
        &lt;layout type="log4net.Layout.RawTimeStampLayout" /&gt;
      &lt;/parameter&gt;
    &lt;/appender&gt;


    &lt;root&gt;
      &lt;level value="Debug"/&gt;
      &lt;appender-ref ref="ConsoleAppender" /&gt;
      &lt;appender-ref ref="FileAppender" /&gt;
      &lt;appender-ref ref="RollingFileAppender" /&gt;
      &lt;appender-ref ref="ADONetAppender" /&gt;
      &lt;appender-ref ref="SmtpAppender" /&gt;
    &lt;/root&gt;
  &lt;/log4net&gt;

  &lt;startup&gt; 
      &lt;supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6"/&gt;
  &lt;/startup&gt;

  &lt;appSettings&gt;
    &lt;add key="log4net.Internal.Debug" value="true"/&gt;
  &lt;/appSettings&gt;

&lt;/configuration&gt;
</code></pre>