views:

112

answers:

2

VS2010 .Net4

Is SubSonic still the tool of choice? Are there easier ways to accomplish the creation of a DAL with the stock tools in VS2010?

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.

TIA

J

+1  A: 

SubSonic is a fine ORM, but it lacks many features that Entity Framework 4 and NHibernate 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 is no 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 & 3 will work just fine in many situations and it may be better for your project to just maintain what is already working.

Michael Maddox
I believe that EF is the route I may explore. We are a small shop and I need to optimize my time, Subsonic did that for me but it just seemed to be inactive for over a year.Thanks for the input.
John
A: 

If u stick on MS SQL database, i can said Subsonic is fine and easy to code. But if u need other non MS database, my suggestion is nHibernate. I just switch back to nHibernate from Subsonic.

mokth