Simple SQL Unit Testing Framework

Framework that greatly simplifies the development of SQL Unit Tests in Visual Studio.

Benefits

Everyone that has used the SQL Unit Tests feature of Visual Studio will know that is far from perfect. The main problems being the weird bugs that prevent properly saving the files, and the cumbersome way of specifying the assertions. Other benefits are:

• No RESX!
• Work directly with MSTest test classes.
• Assertions for a whole table (no more Scalar Value Conditions for each of your cells!)
• Fluent and terse assertions.
• You can paste results from SSMS directly into your assertion.
• Outputs joined SQL.
• Base classes for wrapping your test in a rollbacked transaction, either local or distributed.

Getting started

using Microsoft.VisualStudio.TestTools.UnitTesting;
using SimpleSqlUnitTesting

namespace MyTests
{
    [TestClass]
    public class MyTestClass : LocalTransactionSqlTest
    {
        public MyTestClass()
        {
            TestInitializeAction = Actions.CreateSingle(
                @"sql");
        }

        [TestMethod]
        public void MyTestMethod()
        {
            RunTest(Actions.CreateBlock(@"sql")
            .ResultsetShouldBe(1, @"
11	1	0.143	7
22	2	0.286	7
55	3	0.429	7
66	4	0.571	7
77	5	0.714	7
88	6	0.857	7
133	7	1.000	7")
            .ResultsetShouldBe(2, "6"));
        }
    }
}

Feedback

Please provide feedback and ask questions here.