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 used
in place of
added a connection string to the app.config, then
nonetheless, it didn't like it) and
values and ensured the following in the EF section:
<entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> <providers> <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" /> </providers> </entityFramework>
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: https://github.com/npgsql/npgsql/issues/1514, 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?