npsql connection string

Dapper.FastCRUD.GenericModelGenerator.tt.md

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/obtaining-a-dbproviderfactory

Provider factory make available globally for non .net core / no nuget way

read here : http://www.npgsql.org/doc/connection-string-parameters.html

Installing npsql to GAC is required in order to run pocogenerator for described here https://github.com/MoonStorm/Dapper.FastCRUD/wiki/Entity-registration#autot4

However, this tool will still not work for postgress sql because there is no SchemaReader implementation for postgress in GenericModelGenerator.tt. This tool only work for sql server

#Workaround . Use npsql's poco generator , works well with .net core 2.0

npsql.web.app.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
   
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"/>
    </DbProviderFactories>
  </system.data>

  
  
  <connectionStrings >

    <add name="default" connectionString="User ID=postgres;Password=Password_ChangeIt;Host=localhost;Port=5432;Database=sampledb;" providerName="Npgsql" />
  </connectionStrings>

  
</configuration>

TestProviderFactory.cs

using System.Data;

public struct Program(){


public static void Main(){
 
 //https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/obtaining-a-dbproviderfactory
 
 
  var table = GetProviderFactoryClasses();
  var factory=DbProviderFactories.GetFactory("Npgsql");
  
  
  

}

 static DataTable GetProviderFactoryClasses()
        {
            // Retrieve the installed providers and factories.
            DataTable table = DbProviderFactories.GetFactoryClasses();

            // Display each row and column value.
            foreach(DataRow row in table.Rows)
            {
                foreach(DataColumn column in table.Columns)
                {
                    Console.WriteLine(row[column]);
                }
            }
            return table;
        }
        
}