dotConnect or Entity Developer

dotConnect or Entity Developer

Postby Lucas Phillip » Mon 02 Jul 2012 13:53


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?

Lucas P.
Lucas Phillip
Posts: 10
Joined: Wed 29 Jun 2011 14:37

Re: dotConnect or Entity Developer

Postby Shalex » Tue 03 Jul 2012 14:51

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:

Additionally to changing connection string, you should implement the following:
Devart Team
Posts: 7884
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for PostgreSQL