PostgreSQL data provider missing from wizard in Visual Studio 2015

entity-framework-6 npgsql postgresql sql-server-ce visual-studio-2015


The migration of an Entity Framework 6 SQL Server CE database to PostgreSQL took all day.

I have successfully moved the database across, but I am unable to make the data provider function.

Since our project cannot use.NET 4.5, I first tried the earlier 2.2.7 version of the EF provider, but it didn't work either. I've usedNpgsqlConnection in place ofSqlConnectionStringBuilder added a connection string to the app.config, thenHost I tried.Server nonetheless, it didn't like it) andDatabase values and ensured the following in the EF section:

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
        <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />

Now that I've disregarded this restriction in an effort to make it work, neither the most recent.NET provider (v3.2.2) nor the EF6 v3.1.1 version of the EF provider work.

I also tried installing the VS2015 extension in an effort to re-sync the EDMX from the SQL Server CE to the PostgreSQL replacement, but that just produced a message stating that an error had occurred. I then tried the following:, which opened the window but crashed as soon as I started typing into the boxes. This supplier has vanished once the project was upgraded to.NET 4.5...

Since upgrading, I've also attempted installing the GAC files since it wasn't apparent if the VS extension required them. I've tried uninstalling and reinstalling everything several times and restarting Visual Studio often (also v3.2.2).

Can somebody provide some guidance on how to get all of this functioning the quickest, ideally without needing.NET 4.5?


5/23/2017 6:44:11 AM

Accepted Answer

9/18/2017 11:59:48 AM

Popular Answer


Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow