I'm interested in using an Object-Relational Mapping package for an upcoming project. This project will begin as an ASP.NET application but will have lots of functionality that will eventually be shared with WinForms applications. Can anyone suggest some good, free ORM packages that work well in both ASP.NET and WinForms situations?
SubSonic is not as extensive as nHibernate; rather, it is a straight forward Active Record 1 class per table Data Access Layer.
Some of the features are a query tool, ability to execute stored procedures and a scaffolding app in ASP.net. You can be up and running within 30 minutes or less, with a tiny learning curve and minimal configuration in the Config.app file.
I use NHibernate and NHibernate Annotations. It is working well - without mapping files (entity.xml). Unfortunately you have to at Log4net which requires a tiny xml file.
Habanero, great and powerful ORM. It's free (LGPL license), work with .net 2.0 (it's very important for me) and have a powerful tools for generating model from database (with custom class and properties names, custom validation etc.)