Config Example

[jrocha]

I guess it would be nice to point it out somewhere that DbProviderFactoriesConfigurationHandler is not supported by .NET Core itself and is right now handled by EnterpriseLibrary.

Below is an example of a config file using another provider than default ones.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="system.data" type="System.Data.Common.DbProviderFactoriesConfigurationHandler, Microsoft.Practices.EnterpriseLibrary.Data"/>
  </configSections>


  <connectionStrings>
    <add name="TestMariaDbConnectionString" connectionString="Server=localhost;User ID=root;Password=password;Database=TestDb" providerName="MySqlConnector"/>
  </connectionStrings>

  <system.data>
    <DbProviderFactories>
      <remove invariant="MySqlConnector" />
      <add name="MySqlConnector" invariant="MySqlConnector" description="Async MySQL ADO.NET Connector" type="MySql.Data.MySqlClient.MySqlClientFactory, MySqlConnector" />
    </DbProviderFactories>
  </system.data>
  
</configuration>