No problem with PostgreSQL connection in v2.6, after update the lpg to v3.1 and try to refresh the database schema with test connection button, I got the following error:

Exception message:

Exception type: ConfigurationErrorsException Failed to find or load the registered .Net Framework Data Provider.

LLBLGen Pro version 3.1. Build March 16th, 2011 -----[Core exception]-------------------- at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow) at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.GetDbProviderFactory() at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.CreateConnection() at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData()

Please help.

Thanks

Now LLBLGen since v3 uses DBFactories for database connectivity. For PostgreSql there is a special situation mentioned in the manual:

To make the designer work with the Npgsql ADO.NET provider installed on your system, make sure the DbProviderFactory declaration for the Npsql ADO.NET provider in the LLBLGenPro.exe.config file in the LLBLGen Pro installation folder matches the version and file path of your system. The Npsql ADO.NET provider doesn't install itself in the machine.config so its DbProviderFactory isn't known by the .NET CLR and has to be defined on a per-application basis through the application's .config file.

So go to that .config and make sure it have the correct version of your npgsql driver.

Thanks Daelmo. I have changed the version from 2.0.4.0 to 1.0.0.0. It works.