Using LLBLGen with PostgreSQL 13. There is no .msi installer anymore.

Posts   
 
    
clint
User
Posts: 145
Joined: 15-Nov-2005
# Posted on: 16-Jul-2021 18:38:03   

I'm using LLBLGen 5.6.

I'm trying to use the LLBLGen designer with PostgreSQL 13.

The LLBLGen documentation says:

PostgreSQL support relies on the Npgsql ADO.NET provider, available on GitHub. It's required you use the .msi installer to make sure the npgsql assembly is registered in the GAC and the DbProviderFactory is registered in the machine.config. To be able to create a model from an existing PostgreSQL schema, you have to have access to a PostgreSQL instance, version v7.4 or higher.

But when I went to the GitHub site, it didn't have a .msi installer.

Then I found this page: https://www.npgsql.org/doc/installation.html, that says they don't include it anymore. But they do include it with some older versions of postgreSQL.

Windows MSI Installer

If you need to use Npgsql as a database provider for PowerBI, Excel or other similar systems, you need to install it into the Windows Global Assembly Cache (GAC), and do some special configuration. Npgsql versions prior to 5.0.0 provided a Windows installer (MSI) which does installation for you, and which are still usable and maintained with critical bug fixes. Do not use the Windows MSI installer unless you're sure that your program requires GAC installation - this method is otherwise highly discouraged.

The Npgsql Windows MSI installer for Npgsql 4.1.x can be found on our Github releases page: it will install Npgsql (and optionally the Entity Framework providers) into your GAC and add Npgsql's DbProviderFactory into your machine.config file. Some additional assemblies which are Npgsql dependencies will be installed into the GAC as well (e.g. System.Threading.Tasks.Extensions.dll).

Do you have any suggestions on how I can get the LLBLGen designer to work with newer versions of postgreSQL?

Thanks.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 17-Jul-2021 09:51:54   

You can install the older version of Npgsql, the one that's installed with the msi, as the designer doesn't use features of the newer npgsql. In your generated code you can reference the npgsql nuget package as the driver of the designer for PostgreSQL isn't used at runtime

We'll address this in the next version (v5.9) with a direct reference to npgsql in the driver.

Frans Bouma | Lead developer LLBLGen Pro