BizTalk : Understanding the WCF-SQL Adapter (Adapter Pack v2.0)

My quick scribble on how the WCF Adpater works from an architectue view point:

Ø      Adapter Pack v2.0 can be used on BizTalk 2006 R2 – unless the software assurance has not expired before 1^st May 2009 (Lucky we got this one )

Ø      Can use it outside BizTalk  – via .Net application (License per processor)

Ø      Behind the scene SOAP messages are transformed into ADO.net calls

Ø      Improvements:

o       Query Notification is introduced (used Service broker behind the scenes)

o       Has the Composite transaction capability i.e, Bunch up your SQL command messages and execute all of them in one transaction

Ø     The workflow on the above diagram (non-shaded section) is described by the steps on the right

o       Interesting aspect is mentioning the “WCF Service (Proxy)” – generated by the adapter –> Hosted in IIS –> Can be consumed from other clients