Adding a unit test against programmability objects, such as stored procedures or functions, is part of good practice of programming:
- Create a unit test suite by right-clicking on one of the stored procedures or functions, such as Ch08 | dbo | Stored Procedures | uspTrainTipPredictionModel. Then, choose Create Unit Tests...:
Figure 8.10 Creating unit test in Visual Studio
- Choose the connection:
Figure 8.11 SQL Server test configuration
- Once you click on OK, you will see a new unit test project ...