Overview
In this document we explain how to verify if Stored Procedures are synchronized between our DB and Wayfast. This objects are going to be used with the different objects like Actions, Dataset and Controls depending on the environment that Wayfast users are going to develop the application.
How to verify if Stored Procedure is associated to Wayfast?
Stored Procedure: This is an object in DB that we can create manually in SQL Server Management Studio that allow developers to make inquiries and modify our data given certain procedures.
Click “Database” icon at the top header.
...
On Submenu, selects select “Stored Procedure” subtab
...
Grid view is displayed on screen with all the Stored Procedures associated to our Project. You can observed that the “Object Name” will be the Stored Procedure identification and “Database” column will let us know to which database is associated.
How to create a Stored Procedure and synchronize to Wayfast?
Precondition
On Wayfast, make sure that the Project is created and make a Requirement into “Active” status by clicking “Active Task” button at Navigation left bar.
...
| Note |
|---|
NOTE: This requirement should always be associated to the DB instance from the Project. We will verify later that Wayfast can associate new stored procedures from other DBs without using an active requirement. |
Click “Database” icon at the top header.
...
Notice that the new Stored Procedure is displayed in Grid View.
How to associate a Stored Procedure from a different DB?
Precondition
On Wayfast, make sure that the Project is created and click “End Task” button in case you have an “Active” Requirement at Navigation left bar.
| Note |
|---|
NOTE: Also we need to make sure that these foreign databases are linked to the Project as well as Instances |
...
. |
...
A popup is displayed to change the requirement status
...
Multiassign option allow us to select multiple Stored Procedures at the same time from the same Instance and Database.
...
Clicking the checkbox, Wayfast will save the association and list all the selected objects in Stored Procedure dashboard.
Recap
In this document, we learn how to associate new Stored Procedures created in SQL to our Project’s database. And we observed how Wayfast allows us to search other objects that were not generated specifically to the Project but available in case you want to use it. These foreign objects can only be associated if Project doesn’t have an active requirement in Wayfast and also if the Instance and Database are related like we explained in previous documents through General Options.