Unit Testing Change

In CTP3 I can create a unit test for a stored procedure by right click on the sproc in the list of Schema Objects. In CTP4 this functionallity is missing (at least on my install). Should I be able to see the 'Create Unit Tests...' menu option on the context menu for a sproc



One other thing I've noticed (that may be related) is that in CTP3 the sprocs show as dbo.SprocName while in CTP4 they show as SprocName.sproc.sql (i.e. the file name is shown rather than the name of the stored procedure)




Answer this question

Unit Testing Change

  • Hedgehog Software

    That's what I'd already done :)



  • Antonio_Taganini

    I gotta ask, is this functionality coming back If not, why was it removed

  • Sameer Bhatnagar

    I had a lot of similar problems with CTP4 and just uninstalled it, reinstalled CTP3 and I'm waiting for CTP5.

  • Muhammad Essa

    Thanks, I've fund the Schema view and the menu now appears


  • MB-86

    This should work, did you do this from the Solution Explorer or the Schema View In CTP4 you can only do this from the Schema View not from the Solution Explorer.

    -GertD
    "DataDude" Developement Manager


  • sectorFive

    To make this work in CTP4 do the following:

    1) Select your database project in the Solution Explorer.

    2) Select View | Other Windows | Schema View

    3) Expand the nodes until your find a stored procedure, right-click and there is Create Unit Tests command.

    Cheers,

    Brian Randell
    MCW Technologies


  • Anthony Bellissimo

    It was removed from the solution explorer interface because it is quite possible to have multiple, unrelated types in a single file. The schema-view gives a precise break-down of all of the database objects in the project and we can provide an accurate context menu experience there. For instance, in the next CTP a user can create scripts for functions and table-triggers as well as stored procedures.

    We are looking at how to make the unit test creation wizard more available.



  • Unit Testing Change