I'm looking for a solid ORM for .NET that can handle over a 1000 tables and entities. What can you suggest? Any comments would be appreciated, but those from people who have actually dealt with this challenge and a description of how with what they dealt with it would be appreciated even more.
+1
A:
NHibernate is a terrific choice. Some pointers would include to ensure you fully understand the session life-cycle as well as its lazy-loading techniques for lists and object references.
Ryan Duffield
2008-10-16 16:05:34
+2
A:
You can give a try LLBLGen and ADO.NET Entity Framework, but for the number of tables, the entity class generation will take a while in any ORM...
CMS
2008-10-16 16:17:32
With over a thousand tables, and no specific requirement that you have a beautiful and clean (POCO) domain model, it seems that the OP does want simply to codegen thousands of database classes and work with the database at a slightly more abstract level than writing SQL strings.
Justice
2008-10-16 16:24:04