Support for Composite Operations
The Microsoft BizTalk Adapter for SQL Server enables adapter clients to perform composite operations on the SQL Server database. A composite operation can include any number of the following operations, and in any order:
The Insert, Update, and Delete operations on the tables and views.
Stored procedures that are surfaced as operations in the adapter.
The operations in a composite operation must target tables and views only in a single database.
For information about:
How to perform composite operations in SQL adapter using the BizTalk Server, see Performing Composite Operations on SQL Server by Using BizTalk Server.
Message schemas for the composite operation, see Message Schemas for Composite Operations.
|If there are “n” number of operations in a composite operation that return a result set then “n+1” number of connections are required for the composite operation to be executed. Therefore, you must ensure that the value specified for the MaxConnectionPoolSize binding property is n+1 or greater. For more information about the MaxConnectionPoolSize binding property, see Working with BizTalk Adapter for SQL Server Binding Properties.|
Other ResourcesWhat Operations Can Be Performed Using the Adapter?
© 2014 Microsoft Corporation. All rights reserved.