tSQLt - Database Unit Testing for SQL Server

Database Unit Testing for SQL Server

tSQLt » Dennis

Dennis

tSQLt build.9 Release Notes

by Dennis

Bug Fixes:

  1. When using tSQLt.Run or tSQLt.RunTestClass, if an object name on the dbo schema had the same name as a test class, the test class could not be executed.
  2. If the output of an AssertTableEquals or the length of a test case name was too long, an error was be produced.

New Features:

  1. A new procedure, tSQLt.NewConnection, was added which allows statements to be executed synchronously in a different connection context.

tSQLt build.8a Release Notes

by Dennis

Bug Fixes:

  1. When executing tSQLt.ResultSetFilter, if the result set metadata contained hidden columns then those columns would be returned in the result set output. The values of those columns would be null. Hidden columns are typically present when the base tables of a result set contain primary keys or other constraints which were not selected. tSQLt.ResultSetFilter has been updated to not return the hidden columns.

tSQLt build.8 Release Notes

by Dennis

New Features:

  1. SpyProcedure now supports output parameters. Details are available in the User Guide. See: SpyProcedure.
  2. The first major sections of the User Guide are now available at: – On the right hand side is a link for the User Guide.