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
- To execute a stored procedure, open a workflow, and then insert and configure a Call Method activity.
- From the call method activity configuration panel:
- Optional: For optional parameters, you can pass null values. To do so, perform the following procedure.
- Bind the parameter to a String local variable.
- Insert a Write activity.
- Set the local variable to null from an Object local variable that has a null setting.
- Click Save.
- 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.