Welcome to the second part of a three-part series on Test Driven Development for Business Intelligence projects. Specifically, I’m writing about TDD in .NET with Crystal .NET as the Business Intelligence tool.
In Part 1, I showed how to start a Business Intelligence project using C#, Crystal .NET, and nUnit. This was done in small steps. First, we created a simple test to confirm the loading of the report into our custom object. Next, we created methods for logging onto the database for the Crystal Report object. Finally, we set up a test comprising the logging methods and loading the report into our custom object.
In Part 2 of this series, I show how to write a test that compares the data from the report output to that coming from a straight SQL query.