Are there any 'gotchas' when using EF & PostgreSQL vs MSSQL?

Are there any 'gotchas' when using EF & PostgreSQL vs MSSQL?

Postby Dave5709 » Fri 18 Dec 2009 21:16

All of the documentation & literature I can find on the Entity Framework revolves around MS SQL Server (not surprisingly). Are there any limitations or surprises I need to be ready for when working with the EF and Postgres?

Any input would be greatly appreciated.
Dave5709
 
Posts: 3
Joined: Fri 18 Dec 2009 21:12
Location: Sacramento, CA, USA

Postby AndreyR » Mon 21 Dec 2009 09:44

We cannot call our Entity Framework support for Oracle an ideal one - this ORM was initially designed for MS SQL Server, so the possibility to take into account the marvels of other DBMSs is significantly limited. It is enough to mention only the CROSS APPLY and OUTER APPLY problem discussed here:
http://msdn.microsoft.com/en-us/library/bb896273.aspx
But, in spite of these problems, most of our users are capable of working with Entity Framework successfully and comfortably.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Dave5709 » Thu 24 Dec 2009 10:42

Is the same true of the PostgreSQL support?
Dave5709
 
Posts: 3
Joined: Fri 18 Dec 2009 21:12
Location: Sacramento, CA, USA

Postby AndreyR » Thu 24 Dec 2009 11:52

Absolutely. Sorry for the error.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for PostgreSQL