There lots of ORM(Object Relational Mapper) is available now like entity framework,nhibernate, linq, dlinq but i choose subsonic 3.0 for my next application which will be a question answer site for the following reason
- Now subsonic 3.0 is with linq support so you can write your lambda expression and linq queries along with the subsonic
- It comes with simple repository.
- Built in T4 Templates for 4.0
- Linq to subsonic.
- Subsonic 3.0 templates.
- Can handle thousand of queries at a times.
- Full support with asp.net 3.5 features.
- Ease of Use.
- Great support with asp.net mvc
And another great news is that Rob Conery is hired by the Microsoft and subsonic will official ORM for ASP.net Applications.
You can download subsonic 3.0 from here.