BizTalkGrinch Sandbox – Advanced WCF SQL Transactions and Composite messaging

and the usual correct binding in send port

Another useful SWAT toy in my SANDBOX to remember how to implement a complex WCF SQL transaction using the Composite Messaging strategy with WCF adapter

the sample is …

3 SQL table

3 Stored Procedures

and litle project, note another particular…

I don’t use the Response schemas but only the request SQL schemas.
Many persons use the response SQL schemas without use them, in this toy see how use the request only.

and advanced composite Messaging

To check the correct rollback transaction put in the third procedure a divide by zero error

the source code and bindings here

http://sdrv.ms/1aJUgjk

enjoy