Possible Duplicates:
What ORM frameworks for .NET Do You Like Best?
Which ORM for .net would you recommend?
What is your favorite ORM for .NET?
Which features/tools/facilities made it special for you?
Possible Duplicates:
What ORM frameworks for .NET Do You Like Best?
Which ORM for .net would you recommend?
What is your favorite ORM for .NET?
Which features/tools/facilities made it special for you?
An interesting (though somewhat biased, IMHO) website which compares different ORMs is http://ormbattle.net/.
A Ruby script I made some time ago that was generating all the stuff. Getting the schema from the database, saving it as XML, looping over it and spitting out whatever you convert to a template matching a table. Besides the ORM, there was a lot of UI components, web services, etc. that I added later. I really enjoyed it.
The most prevalent seems to be NHibernate, I imagine due to it's maturity and the fact that it is based on Hibernate for Java. I'm working on learning it now, so that's all i can say about it.
Others in the ORM space are SubSonic and MEF (Entity Framework). I barely know anything about them, other than being NH alternatives.
NHibernate has everything you might need (well almost) and it is open-source
My favorite, and the one I'm using in my current project, is LightSpeed by Mindscape.
It has a great feature set, very good support, and is much more "polished" feeling to use than most of the other options I've tried, including ADO.NET EF and NHibernate/Fluent NHibernate.