For Visual Studio 2010 .NET 4:
Is SubSonic ORM still the tool of choice? Are there easier ways to accomplish the creation of a DAL with the stock tools in Visual Studio 2010?
I need to convert a project that was done with SubSonic 2.03 several years ago and would like to hear opinions on the "right" way to do this.
SubSonic is a fine ORM, but it lacks many features that Entity Framework (EF) 4 and NHibernate (NH) have. SubSonic also isn't moving forward as quickly as EF and NH.
It is possible that SubSonic will be the best .NET ORM two years from now, but that seems highly unlikely at present.
There isn't any one "right" or "correct" answer when choosing a .NET ORM. NHibernate seems like the safest choice right now, while Entity Framework 4 is a good fit for companies that prefer solutions from Microsoft. SubSonic 2 and 3 will work just fine in many situations, and it may be better for your project to just maintain what is already working.