Looking for documentation for writing database-related unit tests in .Net.

Question

Hi, I have heard that MbUnit comes with pretty nice test decorators which allow writing db-related tests with ease.

I am struggling to find good documentation with samples.

Also, can the same thing be achieved with the latest Micosoft's Test package?

Many thanks.

Answer 1

You might want to give some more info on what type of test you want to do ...

Microsoft's Test package is only really useful if you have Team Test. Assuming you do you can test two ways

Raw SQL (only useful if you are testing sps) http://msdn.microsoft.com/en-us/library/bb381703(VS.80).aspx

Data Driven Tests: http://msdn.microsoft.com/en-us/library/ms379625(VS.80).aspx

Other option if you dont* have Team Test is to just use the basic UnitTest in the Unit Test Framework. It is provided with general editions of VS. Problem is you are going to have to basically setup tear down everything. It only gives you descriptors to Initialize/Cleanup/Dependencies/Tests nothing fancies but it gives you the "unit test" feel and ability to perform test runs.