Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit RE: Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

  • February 10, 2011 at 6:15 am

    #1285120

    I would like to be able to create a test around the metadata returned from a stored procedure.

    My scenario :- I will receive Column A, Column B & Column C from a stored procedure.

    If another developer changes the sproc to return another column, Column D, I want my test to fail.

    'Inspect Query' does return the metadata but I can't figure out a way of sticking that into a test.

    Any idea how I can acheive this?