Introduction

DbFit makes test driven database development easy. Depending on whether you are primarily working in a database environment or in a .NET/Java environment, you can look at DbFit as:

• For database developers -- a neat unit-testing tool for stored procedures and database objects, which finally allows you to write database tests in a tabular, relational form, without requiring you to learn or use an object-oriented language.
• For .NET/Java developers -- a set of FIT fixtures which enables FIT/FitNesse tables to execute directly against a database.

This dual nature of DbFit is reflected in two main project goals:

• Support efficient database acceptance and unit testing by providing database developers a good tool to express and manage tests in a relational language, without any .NET/Java knowledge required.
• Support efficient .NET/Java integration testing by providing standardised FitNesse fixtures to manage database state from FitNesse.

Here is a quick overview of DbFit functionality:

• Regression testing for queries and SQL statements
• Functional testing for stored procedures and functions
• Various short-cuts to make writing test scripts easier and more efficient: automatic transaction control, building regression tests for queries, inspecting database meta-data, and more.
• Support for Oracle (Java and .NET versions), MySql 5 (Java) and SQLServer 2000 and 2005 (.NET version).

How this document is organised

Next page: Database unit tests Parent page: Table of contents