Invoke Stored Procedures in SQL using the WCF Service Model

 

The SQL adapter discovers the stored procedures as operations that the adapter clients can invoke on the WCF client to invoke the stored procedure. Based on how the stored procedure returns the result set, the adapter categorizes all the stored procedures as:

  • Procedures. Invoking stored procedures from the Procedures node returns an array of DataSet.

  • Strongly-Typed Procedures. Invoking stored procedures from the Strongly-Typed Procedures node returns a strongly-typed result set.

Note that the same set of stored procedures in the database you connected to will be listed both under the Procedures and Strongly-Typed Procedures node. Based on the kind of result set you want, you must invoke the stored procedure from the relevant node. For more information about how the SQL adapter supports stored procedures, see Execute Stored Procedures in SQL Server using BizTalk Server.

This section provides instructions on how to invoke stored procedures from both the Procedures and Strongly-Typed Procedures node by using a WCF client.

Develop applications using the WCF Service model

Show: