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


Related blog posts