Roy Osherove blogs that he was mistaken when he suggesting using mocks for data access code. With the improved Rollback attributes that he helped create, along with people like Justin Burtch who created a similar attribute for VSTS, they are now thinking that this is the way to go: rolling back database changes.
Roy is no fan of VSTS testing, finding a few bugs and some questionable design decisions. Those don’t seem like deal breakers for me, but we will see.