Export (0) Print
Expand All

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:

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.

See Also

© 2014 Microsoft Corporation. All rights reserved.
© 2015 Microsoft