Develop BizTalk applications using the SQL adapter

Developing BizTalk applications involves creating a BizTalk project in Visual Studio and using the Consume Adapter Service BizTalk Project Add-in or Add Adapter Metadata Wizard to generate XML schema. Once you have generated the schema, you can either use Content-Based Routing (CBR) or create BizTalk orchestrations to send and receive messages that conform to the generated schema.

CBR can be used in scenarios where the messages being sent to SQL Server do not require any intensive processing. For example, if you know that the receive port will receive messages only of a certain type, you can add a filter to the send port to route messages that match the filter expression to the send port.

In BizTalk orchestrations, you create send and receive ports to send and receive messages to and from the WCF-Custom adapter, which in turn sends the messages to BizTalk Server. This section provides information about using BizTalk orchestrations to perform operations on SQL Server using the SQL adapter. The SQL adapter in turn uses the WCF-Custom adapter, which can interact with a WCF binding.

Important

To use the SQL adapter with Microsoft BizTalk Server, you must always set the EnableBizTalkCompatibilityMode binding property to True. For information about how to set binding properties, see Configure the binding properties for the SQL adapter.

In This Section

• Prerequisites to create SQL applications using the SQL adapter

• Building blocks to develop BizTalk applications with the SQL adapter

• Insert, Update, Delete, and Select Operations on Tables and Views with the SQL adapter

• Run Operations on Tables and Views with Large Data Types using the SQL adapter

• Execute Stored Procedures in SQL Server by Using BizTalk Server

• Execute Stored Procedures With a Single XML Parameter

• Execute Stored Procedures Having a FOR XML Clause in SQL Server using BizTalk server

• Run Composite Operations on SQL Server by Using BizTalk Server

• Invoke Scalar Functions in SQL Server by Using BizTalk Server

• Invoke Table-Valued Functions in SQL Server by Using BizTalk Server

• Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery Operations by Using BizTalk Server

• Polling SQL Server by Using the SQL Adapter with BizTalk Server

• Receive SQL Query Notifications by Using BizTalk Server

See Also

Develop your SQL applications