dotConnect or Entity Developer

dotConnect or Entity Developer

Postby Lucas Phillip » Mon 02 Jul 2012 13:53

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.
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: http://www.infoq.com/articles/multiple-databases.

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


Return to dotConnect for PostgreSQL