Devart Forums

Greetings!

We have an app that uses EF4.1 to connect to our SQLServer database. We need to change our dbms and we're going to use Postgre.
I've been looking around and I could't figure out which component is right for what I need. I got everything working with EF 4.1 and wanted only to change my connector to postgre, so that the change is transparent to my application.

Am I able to do that with dotConnect or with Entity Developer?

Thanks,
Lucas P.

We recommend you to use dotConnect for PostgreSQL Professional Edition. As for migration from SQL Server, please take into account that PostgreSQL has limitations/differences in behaviour comparing to SQL Server. Some of them are listed here: http://www.infoq.com/articles/multiple-databases.

Additionally to changing connection string, you should implement the following:

• turn on the IgnoreSchemaName option (http://blogs.devart.com/dotconnect/enti ... qlite.html)
• if you used Linq to Entities functionality of database-specific class System.Data.Objects.SqlClient.SqlFunctions, find the corresponding function in Devart.Data.PostgreSql.Entity.PgSqlFunctions