dotConnect or Entity Developer

[Lucas Phillip]

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.

[Shalex]

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