ORM for Database with 1000+ Tables

Question

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.

Answer 1

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...

Answer 2

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.