Unit testing Database problem[VS2005]

[Snowjim]

Hey! I have looked allover the internet after a way to do unit testing against a database with rollback as easy and flexible as possible. I found this article: http://msdn.microsoft.com/msdnmag/issues/05/06/UnitTesting/[^] (http://msdn.microsoft.com/msdnmag/issues/05/06/UnitTesting/default.aspx?loc=&fig=true#fig5[^]) And I have tried to do the exact thing that roy Osherove shows. I have two projects(dbContextTest(class library) and dbContextTest_Test(Test project)) The following class are placed within the dbContextTest class and is that class that I want to test: public class userHandler { private databaseHandler dbHandler = new databaseHandler(); public bool createUser(string inFirstName, string inLastName) { try { if(dbHandler.createUser(inFirstName, inLastName) > 0) return true; return false; } catch (Exception ex) { Console.WriteLine("Error in " + this.ToString() + ".createUser : " + ex.Message); return false; } } } As you can see, I am here contacting the DAL(Database handler(dbHandler)) to add a user to the database. In my test project I have a userTest class where I have my test methods: [ClassInitialize()] public static void MyClassInitialize(TestContext testContext) { ServiceConfig config = new ServiceConfig(); config.Transaction = TransactionOption.RequiresNew; ServiceDomain.Enter(config); } [ClassCleanup()] public static void MyClassCleanup() { if (ContextUtil.IsInTransaction) ContextUtil.SetAbort(); ServiceDomain.Leave(); } [TestMethod()] public void createUser() { string firstName = "Olle"; string lastName = "Svensson"; userHandler tmpUSHandler = userFactory();