UPDATE: I have since moved these articles to my own blog and they can be found here.
Whew. My 9th and final article for TopXML.com on integrating BizTalk Server and WCF is now published. This one looks at the BizTalk Adapter Pack and how to consume the Oracle adapter from inside BizTalk Server. I demonstrated how to insert multiple records at once, call stored procedures, build a database polling solution, and how to call the Adapter Pack from an orchestration using code.
20,500+ words and 178 screenshots later, I definitely learned a lot about WCF (and Oracle) by writing this series of articles. I found the security and attachment topics to be challenging, the transaction topics to be quite interesting, and the BizTalk Adapter Pack to be quite compelling. The WCF integration in BizTalk Server 2006 R2, while not as rich as it could be, is actually pretty darn well built and thought out.
When I started out on this series, I figured that writing about BizTalk/WCF and then the BizTalk Adapter Pack would be somewhat “niche” for the majority of developers, but, hopefully this helps people down the line as they begin to really investigate and evaluate these technologies together.