Recommendation of ORM for large applications
Is object relationship mapping (ORM) ex. entity framework recommended for large application base spanning across 150 projects or so. With more than 500 tables and respective mappings?
Pavan Kumar Kota, Mar 21, 2012
The ORM is a pain atleast in our case where in the loading of the DB schema into the Entity model took a very long time sometimes spans to morethan 20 mins. On top of it any inclusion of new table or so, we need to reload/generate the model again. Is there anyway where in we can split the DB schema into small models and handle them independently? So that entire db model need not have to be regenerated again? is anyone experience breaking the complete db model into minor EF models and used unit of work pattern for affecting the changes to morethan one EF model? is it possible?
Mar 26, 2012
Great answers.. Just my two cents...
We are recently migrating our core banking solutions to asp.net mvc and EF4.1+. So far good. The application has
about 450 tables, with complex logics for various banking operations..
The EF is coming good for us, in terms of performance as well. We are yet to face any issues.... But we are still in the POC's stage and hopefully within in couple of months we will be fully moving to EF, if we don't hit any major roadblock.
Rajesh Pillai, Mar 25, 2012
Great response from Hector, but I would also recommend you to evaluate LLBLGen, http://llblgen.com
Robert Blixt, Mar 23, 2012
Your choice depends on what your requirements are. The top 3 ORMs for large projects (in my experience) are:
Here is a list of some very light and fast ORMs. I only recommend these, if the developers are very good with SQL.
Hector Sosa, Mar 21, 2012