DbUnit.NET Alternatives

Question

Are there other '.NET (2.0) Unit Testing Framework for Database Access Code' besides DbUnit.NET?

I've been trying DbUnit.NET and some things are not supported. Also, the project seems to be in alpha since 22nd May 2006...

We are refactoring our architecture to be able to do tests with mocking frameworks, but until that work is done I'd like to have a framework like DbUnit.NET (but better).

Answer 1

I ran into this problem a few years ago. I was annoyed at the state of DBUnit.Net. It was missing features that were important to me. Thanks to IKVM, it's not very difficult to use the normal Java version of DBUnit from dotnet. As a matter of fact, I'm running C# integration tests right now that are using the original DBUnit. Here's how I converted the java version of DBUnit into a .Net assembly:

• Download IKVM
• Place the following jars into a common directory: commons-collections-3.2.jar commons-logging-1.1.jar junit-4.1.jar commons-lang-2.2.jar dbunit-2.2.jar sqljdbc.jar

Now, from the command line with a working directory of the common jar directory:

ikvmc -target:libary -keyfile:yoursignature.snk -debug -version:2.2.0.0 -out:dbunit.dll *.jar

You can get necessary libraries from the following locations:

• commons-* Apache Commons
• dbunit.jar DbUnit homepage
• sqljdbc.jar MSDN
• junit.jar Junit homepage

If you are not using SQL Server as your database, then replace sqljdbc.jar with the appropriate JDBC driver. To use DBUnit directly from your .Net code, include dbunit.dll and the appropriate IKVM assemblies.

The jar versions I have given here are old. My notes on this subject are almost three years old. Newer versions will probably work, but I have not tried them.

Answer 2

We're using NDbUnit for one of our projects. It's a far more active project than DbUnit.NET appears to be.

Answer 3

Also, to consider is tdunit.