When using XPO, you can call the Session.ExecuteSproc method to execute a stored procedure. Use the TransactionalGetObjectSpace activity to obtain an underlying instance of the XPObjectSpace class and then use CodeActivity or InvokeMethod to execute an appropriate method of the Session object. This example demonstrates how to execute a stored procedure in the Workflow Designer and in code.
Files to look at:• CustomNativeActivity.cs (VB: CustomNativeActivity2.vb)
• CustomNativeActivity2.cs (VB: CustomNativeActivity2.vb)
• WinApplication.cs (VB: WinApplication.vb)