Skip to content

Instantly share code, notes, and snippets.

@mynkow
Last active January 24, 2023 22:38
Show Gist options
  • Save mynkow/6882536 to your computer and use it in GitHub Desktop.
Save mynkow/6882536 to your computer and use it in GitHub Desktop.
Configure postgres connection string and providerName
<connectionStrings>
<add name="postgres" providerName="Npgsql" connectionString="Server=127.0.0.1;Port=5432;Database=MyDB;User Id=postgres;Password=postgres;"/>
</connectionStrings>
<connectionStrings>
<add name="postgres" providerName="???" connectionString="Server=127.0.0.1;Port=5432;Database=MyDB;User Id=postgres;Password=postgres;"/>
</connectionStrings>
<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=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.12.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"/>
</DbProviderFactories>
</system.data>
"C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\gacutil.exe" -i "C:\Program Files (x86)\PostgreSQL\Npgsql\ms.net4.0\Npgsql.dll"
"C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools\gacutil.exe" -i "C:\Program Files (x86)\PostgreSQL\Npgsql\ms.net4.0\Mono.Security.dll"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment