I am currently working on a project that has a fair amount of backend database processing happening. I have got a fair amount of TDD experience in a C# environment and have found that once you get into TDD it becomes a way of life. As such, I wanted to apply the same approach to my database development.
After a bit of researching I stumbled across an Open Source unit testing framework for SQL Server called tSQLt. I have been using it for a few weeks now and yesteday I past the 100 test mark in the project I am working on. It took me a little while to get up and running with some of the concepts and idea's around tSQLt unit testing, but I am already feeling very comfortable writing database unit tests using tSQLt.
There is a very good series of blog posts on tSQLt already at http://datacentricity.net/tag/tsqlt/
Over the next few days (I hope). I will try to put together a series of post's showing the basics working of each test type without any extra logic to get in the way of what is going on.
No comments:
Post a Comment