Microsoft BizTalk Server 2010 Patterns

Updating the inventory

We are nearing the end of our solution, but we do have one final challenge to address. We must update the products table that launched our notification, as well as conditionally updating the vendors table if the order was approved and placed.

We could perform these in separate send operations from our orchestration, but this could result in inconsistent states in our database if the first operation succeeds and the second one does not. We could handle these with compensating actions or other approaches, but it is far easier to simply use the transactional nature of the WCF-SQL adapter itself to accomplish these goals for us. We are going to do this with a composite operation on the WCF-SQL adapter, which allows us to group ...