dotConnect or Entity Developer

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Lucas Phillip
Posts: 10
Joined: Wed 29 Jun 2011 14:37

dotConnect or Entity Developer

Post by 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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect or Entity Developer

Post by 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:
  • 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

Post Reply