What Operations Can Be Performed Using the Adapter?

You can use the adapter clients to perform operations on the SQL Server database by:

  • Creating BizTalk projects

  • Using the WCF service model

  • Using the WCF channel model

The Microsoft BizTalk Adapter for SQL Server exposes operations that applications can invoke on it and that it can, in turn, invoke on applications. These operations are invoked by sending SOAP messages over a channel. If a response is required, it is returned in a SOAP message over the same channel. For information about the message structure and the SOAP action associated with each operation, see Messages and Message Schemas for BizTalk Adapter for SQL Server.

This section provides information about the operations supported on the SQL Server database using the SQL adapter.