MSDN Library

Overview of BizTalk Adapter for SQL Server

The Microsoft BizTalk Adapter for SQL Server exposes the SQL Server database as a WCF service. Adapter clients can perform operations on the SQL Server database by exchanging SOAP messages with the adapter. The adapter consumes the SOAP message and makes appropriate ADO.NET calls to perform the operation. The adapter returns the response from the SQL Server database back to the client in the form of SOAP messages.

The SQL adapter surfaces metadata of artifacts in the SQL Server database (such as tables, views, and procedures). This metadata describes the structure of a SOAP message in the form of Web Services Description Language (WSDL). The SQL adapter uses the Add Adapter Service Reference Visual Studio Plug-in, Add Adapter Metadata Wizard, and Consume Adapter Service BizTalk Project Add-in to enable adapter clients to retrieve metadata for operations. The adapter also generates programming artifacts that can be used in your programming solution. For more information about Add Adapter Service Reference Visual Studio Plug-in, Add Adapter Metadata Wizard, and Consume Adapter Service BizTalk Project Add-in, see Connecting to SQL Server in Visual Studio.

The SQL adapter uses ADO.NET to communicate with the SQL Server database. You can use the SQL adapter to communicate with the SQL Server database in the following ways:

In This Section

See Also

© 2014 Microsoft Corporation. All rights reserved.
Show:
© 2016 Microsoft