I'm interested to find out which ORM has best support for Postgres SQL database? Does any mapper have, both, LINQ support and ability to generate model from database?
Any expirience? Performance, LINQ support...
Marko
2010-05-31 08:54:35
`LINQ support and ability to generate model from database`... Yes it does!!!
Veer
2010-05-31 09:01:22
You shouldn't be generating a model from your database anyway. Your object model should reflect the behavior of your system - not the data, which is what a relational database structure is optimized for.
Keith Rousseau
2010-06-02 15:52:04
+1 NHib is be great, and you should think in terms of the making the technology fit your application. Not the other way around. There is a linq provider for NHib; also Fluent NHibernate makes setting up NH easier.http://fluentnhibernate.org/
joshc
2010-08-03 17:26:18
+2
A:
I haven't compared it against DbLinq but LlbgenPro supports Postgres and is very strong. It supports both Linq and generating the model from the database. In it's just released v3.0 it can generate projects not just for the LlblGen runtime but also for NHibernate, Entity Framework and LinqToSql.
It should be in your list to evaluate.
automatic
2010-06-02 15:49:21
Agreed. We have used both LLBLGenPro and NHibernate to access PostgreSQL databases with much success.
Jess
2010-08-02 18:55:14