The specified invariant name 'MySql.Data.MySqlClient' wasn't found in the list of registered .NET Data Providers

Question

I have a C# Library developed using .Net Standard 2.1 and this library is called in a test console application built on .Net Core 3.0. But at run time, the GetFactory is throwing an exception.

 private DbConnection connection;
 connection = DbProviderFactories.GetFactory("MySql.Data.MySqlClient").CreateConnection();

Exception:

DbProviderFactories.GetFactory The specified invariant name 'MySql.Data.MySqlClient' wasn't found in the list of registered .NET Data Providers.

I have installed MySqlConnector 1.2.1. But it didn't help. And also adding the below in app.config file.

<system.data>
 <DbProviderFactories>
  <remove invariant="MySql.Data.MySqlClient" />
  <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.23.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
</system.data>

Bradley Grainger · Accepted Answer · 2021-01-27 14:02:44Z

7

The XML you've shown for app.config only works in .NET Framework applications.

For .NET Core 2.1 or later, call DbProviderFactories.RegisterFactory. The exact arguments you pass will depend on the factory you want to register (and the NuGet packages you have installed):

// MySqlConnector (my personal recommendation for .NET Core)
DbProviderFactories.RegisterFactory("MySqlConnector", MySqlConnector.MySqlConnectorFactory.Instance);

// MySql.Data (may be needed instead if other code is hard-coded to "MySql.Data.MySqlClient")
DbProviderFactories.RegisterFactory("MySql.Data.MySqlClient", MySql.Data.MySqlClient.MySqlClientFactory.Instance);

For more information, see Using DbProviderFactories.

answered Jan 27, 2021 at 14:02

Bradley Grainger

28.3k4 gold badges95 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ullan Over a year ago

Your solution resolved the posted issue. But GetConnectionString(true) method is throwing an exception "The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception." . I know this is a different issue.

Ullan Over a year ago

Thanks for your help, I forgot to remove the above app.config settings and that was causing the ReplicationManager exception. After removing the app.config, its working now!

Bradley Grainger Over a year ago

@Ullan That error has been reported frequently against MySql.Data (e.g., stackoverflow.com/a/65496771/23633, stackoverflow.com/a/60786792/23633) which is why I recommended MySqlConnector for .NET Core instead.

Collectives™ on Stack Overflow

The specified invariant name 'MySql.Data.MySqlClient' wasn't found in the list of registered .NET Data Providers

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related