I have been wanting to post about this for a while but have forgotten to do so. Roy Osherove did a really cool post on how to use Enterprise Services (which come with the framework) to simplify the clean-up after database testing.
He basically uses the builtin transaction support to rollback after each test is complete. This is definitely something I will be incorporating in my future tests of DAL components.
Anyway he has some great code examples you should check out if this stuff at all interests you.
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in any way.