Unit testing data access

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.


The BindingList is very nice, but doens’t support some things like sort and filter that a lot of people would like to have (see here for a short discussion on BindingList vs Datatable).

This project, in sourceforge, called BindingListView is supposed to allow you to get a sorted or filtered “view” of a bindinglist.

Might be worth checking out.