For ORMs mostly LinqToSql, nHibernate. LinqToSql has been really easy to work with. My most recent project I have four physical data sources. L2s + repository pattern worked like a champ.
In a couple of cases I've had a chance to use MVP guidance packages and Asp.Net MVC.