FairCom Java & .NET Stored Procedures

SqlStoredProc

SqlStoredProc is the class that implements a .NET stored procedure. To create a stored procedure, a new class derived from the SqlStoredProc class must be created. This class must implement the Execute() method, which is the method called by the server. The Visual Studio Extension automatically performs the following:

• It generates the class.
• It generates the Execute() method and adds proper code to exchange the stored procedure parameters with the server.
• It creates an ExecuteSP method, which is the method to be implemented.

SqlStoredProc Class Description

This class inherits from SqlSpBase. It adds the following additional methods.

Constructor

SqlStoredProc()

Public Methods

void NewResultSetRow()

Return an SqlSpRow object having columns defined as per the stored procedure result set definition. See the SqlSpRow description to learn how to obtain access to column definition and values.

void ResultSetAddRow(SqlSpRow row)

Add a row to stored procedure result set. The row content is copied into an internal structure such that the row object can be reused.