Database unit testing with the MassDataHandler
Hello,
Unit testing the database is usually a difficult, tedious, brittle task. However our company recently open-sourced a tool that makes it much easier. We call it the "MassDataHandler", and it's free on Microsoft's CodePlex site.
"The MassDataHandler is a framework to assist with Database Unit Testing. The framework makes it very easy to insert test data into a database, which in turn makes it very easy to write database unit tests. The user merely needs to specify their relevant data in a simple XML fragment, and then the framework uses knowledge of the database schema to do all the grunt work and convert that XML data into SQL, from which it populates the database.
The XML fragments that contain the test data are robust and refactorable. You can include expressions like variables substitution and identity lookup, default row templates, and include statements to import sub-templates. Because the framework already knows the database schema, you only need to specify the relevant data, and the framework can auto-populate the rest of the row’s required columns with dummy data."
You can view it here:http://www.codeplex.com/Wiki/View.aspx?ProjectName=MassDataHandler
