Page 1 of 1
Are there any 'gotchas' when using EF & PostgreSQL vs MSSQL?
Posted: Fri 18 Dec 2009 21:16
by Dave5709
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.
Posted: Mon 21 Dec 2009 09:44
by AndreyR
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.
Posted: Thu 24 Dec 2009 10:42
by Dave5709
Is the same true of the PostgreSQL support?
Posted: Thu 24 Dec 2009 11:52
by AndreyR
Absolutely. Sorry for the error.