Unit Testing Database Logic for SQL Server Database Developers

I haven't tried it, but Karl Gram seems to be cooking up something interesting - dbUnit for unit testing database logic.

dbUnit aids the developer in creating unit tests for all your database logic. You can test the table structure, inserts, updates, deletes, triggers and also procedures. In general the tool allows you as a developer to write all your unit tests in T-SQL and use NUnit to unit test them.

Some of the features of the current alpa version (0.5) are:

• Create a dbUnit project
• Add unit tests to the project
• Specifiy the SQL Server to connect to
• Handle expected exceptions (e.g raiserror and other database errors)
• Generate the NUnit test dll
• Start NUnit from within dbUnit

Learn more here.

Recent SQL Server related posts:

• SQL Server Transaction Savepoints - Rollback Part of Transaction - SqlTransaction.Save - SqlTransaction.Rollback
• Sql Server Transactions - ADO.NET 2.0 - Commit and Rollback - Using Statement - IDisposable
• SQL Server - Optimistic Concurrency Database Updating - Pessimistic Concurrency - High Performance ASP.NET Websites
• SQL Server Queries - SQL Server Query Tips and Tricks for Efficient SQL Server Query Performance
• Query Analyzer - Sql Server Database Indexes and Execution Plans

Source: David Hayden ( Florida ASP.NET Developer )

 

posted on Sunday, December 18, 2005 6:35 PM