LLBLGen Pro + MySql + .NET7 => No DbProviderFactory has been configured for this DQE

Posts   
 
    
18548
User
Posts: 5
Joined: 22-Jun-2023
# Posted on: 13-Sep-2023 19:42:49   

Hello,

I'm in the middle of migration from .NET Framework 4.8 to .NET 7. Most recent problem is that I'm getting errors like the one bellow:

"No DbProviderFactory has been configured for this DQE. You have to use the DQE configuration system to register at least one DbProviderFactory."

I've installed "dotConnect for MySQL 9.1 Professional Trial" as I've read that Express edition is no good for .NET. I'm still getting an error. What am I missing?

In the same project I'm also using MSSQL so my configuration looks like this. Maby it's missing some part about mysql?

                RuntimeConfiguration.ConfigureDQE<SQLServerDQEConfiguration>(
                                                c => c.SetTraceLevel(TraceLevel.Verbose)
                                                      .AddDbProviderFactory(typeof(SqlClientFactory))
                                                      .AddCatalogNameOverwrite("DB", cdnName)
                                                      .AddCatalogNameOverwrite("DB2", optimaName));
18548
User
Posts: 5
Joined: 22-Jun-2023
# Posted on: 13-Sep-2023 20:06:40   

Solved.

I've downloaded Devart.Data.MySql from NuGet and added:

RuntimeConfiguration.ConfigureDQE<MySqlDQEConfiguration>(c => c.AddDbProviderFactory(typeof(Devart.Data.MySql.MySqlProviderFactory)));