October 2011

Unit Testing Databases with tSQLt Part 3 – testing table constraints

29 October 2011

In Part 2, we looked at the first couple of tests for a new table; that it exists and with the correct structure (columns, data types etc). In this part we are going to write the rest of the tests we need to cover this table effectively. We will be validating the primary key, the IDENTITY [...]

Read the full article →

Unit Testing Databases with tSQLt Part 2 – testing table structure

19 October 2011

In Part 1, I worked through setting up the tSQLt unit testing framework in a development database for the first time. In this post, we are going to start writing our first tests for the first piece of functionality to be implemented in Log4TSql which is an open source database logging and exception handling block [...]

Read the full article →

Unit Testing Databases with tSQLt Part 1 – Installation and Setup

13 October 2011

This is the first in a series of articles about my experiences (re)creating a database project from scratch using the tSQLt unit testing framework. I will be using an open source project I have been playing with on and off for a few years – Log4TSql which is an open source database logging and exception [...]

Read the full article →

Test Driven Development (TDD) for Databases – Choosing a framework

8 October 2011

I’ve been a fan of test-driven development (TDD) for a long time. My primary skill set revolves around database design and development but I like to think that, whilst not a .Net expert, I have pretty good C# skills for a SQL bod. So I have had the opportunity to follow proper TDD methodolgies on several [...]

Read the full article →