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.
