Database unit test execution sequence logging

Data and Databases
1

I’m having trouble with my database project’s stored procedure tests. I’ve got about 50 unit tests. They all pass when run separately but fail during a group run. I think the execution order is messing with the data in some tables.

Is there a way to see the test execution sequence? The test window only shows start and end times for the whole batch. It’d be super helpful to see something like:

Test discovery started
52 tests found (0.4 seconds)
Test run started
TestA started
TestB started
Test run finished (13.5 seconds)

This would help me figure out why tests that work alone fail in a group. Any ideas on how to get this kind of detailed log? Is it even possible with the current setup?

2

Yo SwiftCoder15, sounds frustrating! have u tried adding timestamps to ur test methods? like Console.WriteLine(DateTime.Now + " - TestA starting"); at the beginning of each test. might help track the sequence. also, check if ur db is resetting properly between tests. good luck man!

3

hey swiftcoder15! that sounds like a tricky situation. have u tried using a test runner framework like xUnit or NUnit? they often have built-in logging options that might give u more detailed execution info. or maybe u could add some custom logging to ur tests? just a thought! what kinda database are u working with btw?