Database procedures and triggers

Making Database Connections, Authentication Options, Connecting to Microsoft Access, Connecting to MS SQL Server, Connecting to Oracle, Connecting to MySQL and Connecting to Third-Party Databases.
Post Reply
sai
Posts: 25
Joined: Mon Apr 01, 2019 10:52 am

Database procedures and triggers

Post by sai » Wed Apr 17, 2019 5:17 pm

How to test database procedures and triggers?

Teja Reddy
Posts: 38
Joined: Sun Mar 31, 2019 6:24 am

Re: Database procedures and triggers

Post by Teja Reddy » Wed Apr 17, 2019 5:22 pm

To test database procedures and triggers, input and output parameters must be known. EXEC statement can be used to run the procedure and examine the behaviour of the tables.

1)Open the database project in solution explorer
2)Now in View menu, click the database schema
3)Open the project folder from schema View menu
4)Right click on the object that has to be tested, and then click on the dialog box that says Create Unit Tests
5)After that create a new language test project
6)Select either a) Insert the unit test or b) Create a new test and then click OK
7)Project that has to be configured will be done by clicking on the Project Configuration dialog box.
8)Once it configured click on OK

Post Reply

Return to “Database Connections”