DataLayer.SP - Using Studio's DataLayer Wizard
Logi Studio includes a wizard that can assist you in configuring DataLayer.SP. The wizard assumes that you have already added an appropriate database Connection element in the _Settings definition and configured it.
As shown above, the wizard can be started by selecting and then right-clicking the parent element under which you want to add the datalayer, and using the context menus to select "Add a Stored Procedure DataLayer". The wizard will open; use it as follows:
- Select the ID of the Connection element from the drop-down list of available connections. Click Next to continue.
- Select the desired stored procedure from the drop-down list of available stored procedures. Click Next to continue.
- Click Next to have the wizard insert the DataLayer.SP and any SP Parameter elements it requires.
- Click Finish to close the wizard.
- The wizard has inserted the datalayer and configured its attributes, as shown above, and has also inserted and configured the required SP parameters. The input parameters have been configured assuming that @Request tokens will be used to provide their values.