Application Lifecycle Management for SQL Server Database Development

Play Application Lifecycle Management for SQL Server Database Development
Sign in to queue

The Discussion

  • User profile image
    Rigaux

    A must seen session. No Marketing, just what you need to know.

  • User profile image
    kevcunnane

    During the session we had several questions about database unit testing, in particular how to write data driven tests and how to implement mocking support. I mentioned that these were not built-in but that they could be supported by use of T4 templates (for data-driven testing) and use of the TSQLT framework (for mocking support). The blog posts that cover how to set this up are by Steven Wright. The main post is Integrating tsqlt with Team Foundation Build Services continuous buildating-tsqlt-with-team-foundation.html. This covers using T4 templates to generate the necessary database unit test classes (as shown in the demo) so that TSQLT tests can be run as part of Continuous Integration. The same process could be used to automatically output data-driven tests with a little bit of work. 

     

Add Your 2 Cents