BizTalkGrinch Sandbox – Advanced WCF SQL Transactions and Composite messaging

schema

and the usual correct binding in send port

compo

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

tr1tabelle

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.

orch

 

and advanced composite Messaging

 

 

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

erroretre

 

 

the source code and bindings here

http://sdrv.ms/1aJUgjk

enjoy

Related blog posts