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 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