PostgreSQL - sjh37/EntityFramework-Reverse-POCO-Code-First-Generator Wiki
The generator is a T4 template that runs externally to your project, and therefore cannot make use of any nuget packages you have installed into your project. It can however use ones that are installed in the GAC. Therefore the PostgreSQL
npgsql.dll file needs to be installed into the GAC to make it accessible to the generator.
To install npgsql into the global assembly cache (GAC) I ran the following command:
cd C:\Users\[user]\.nuget\packages\npgsql\184.108.40.206\lib\net461 gacutil.exe /i Npgsql.dll
Notice I am using the
.NET 4.6.1 version because the generator runs as a T4 template using .NET, and not a .NET Core template. It does not matter if you are generating code for .NET or .NET Core, the generator is run outside of your project as a .NET program.
Looking at which version I have installed with
gacutil /l npgsql shows the following:
Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.0 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following assemblies: npgsql, Version=220.127.116.11, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7, processorArchitecture=MSIL Number of items = 1
Which means I have v4.1.3 installed.
at approximately line 168 I have the following
system.data xml where you will see the Npgsql Data Provider has been added
<system.data> <DbProviderFactories> <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> <add name="Npgsql Data Provider" invariant="Npgsql" description=".NET Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=22.214.171.124, Culture=neutral, PublicKeyToken=5D8B90D52F46FDA7"/> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=126.96.36.199, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/> </DbProviderFactories> </system.data>
I modified both. However to find the exact one which is used by the generator, in your
<database>.tt file very near the bottom, un-comment
fileManagement.WriteLine("// " + System.Runtime.InteropServices.RuntimeEnvironment.SystemConfigurationFile);
<database>.tt and inspect the first line in generated output. I have the following listed:
So that is the exact file the generator will use, and is the one that is required to have the above npgsql XML added.
Further reading here.