PurpleFlux: Maybe even the EntitySpaces team would consider making a Test DataProvider that we could programmatically set up and use for tests (probably just really using a dataset or something). Another approach might be to use the MSAccessProvider. Set up an access db with the appropriate data and for each unit test which requires it you could ...

David.Parsons: But, think of the second tier as a combination of Custom+Generated, rather than BLL+DAL. And, do not try to further separate them.   A simple version of another question I've asked (but not yet had answered).  With BLL + DAL, you can unit test the BLL without  referencing a live database (ie, you ...