Messages and Message Schemas for BizTalk Adapter for SQL Server

Overview

The Microsoft BizTalk Adapter for SQL Server is a Windows Communication Foundation (WCF) custom binding. It 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.

As a WCF service, the SQL adapter exposes metadata for its operations and data types by using standard WCF mechanisms. The sections in this topic describe the XML structure of the messages and data types that the SQL adapter uses.

In This Section

• Basic SQL Server Data Types

• Message Schemas for Insert, Update, Delete, and Select Operations on Tables and Views

• Message Schemas for Procedures and Functions

• Message Schemas for the Polling and TypedPolling Operations

• Message Schemas for Query Notification

• Message Schemas for Composite Operations

• Message Schemas for the ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations