Configure a stored procedure for using the SQL service provider

After creating a database connection, you can configure stored procedure for a SQL service provider.

Procedure

  1. To execute a stored procedure, open a workflow, and then insert and configure a Call Method activity.
  2. From the call method activity configuration panel:
    1. Click Configure Method.
    2. Expand IDatabaseService, select ExecuteProcedure, and then click Next.
    3. In the Procedure section, click Browse next to Connection.
      The Universal Browser appears.
    4. Select a database connection, and then click OK.
      The available user-defined stored procedures are displayed in the Procedure drop-down list.
    5. Select a procedure to execute, and then click Finish.
    6. From the call method activity configuration panel, in the Inputs section, you can configure any required input parameters.
      Note: The Connection and ProcedureName fields are read only.
    7. Click Save.
  3. Optional: For optional parameters, you can pass null values. To do so, perform the following procedure.
    1. Bind the parameter to a String local variable.
    2. Insert a Write activity.
    3. Set the local variable to null from an Object local variable that has a null setting.
    4. Click Save.
  4. Optional: You can also execute a procedure from WPF and Silverlight forms by invoking a server method. For more information, see Bind a return value to a DataGrid using form server methods.