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.
Are there any 'gotchas' when using EF & PostgreSQL vs MSSQL?
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.
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.