I’ll admit to being fairly underwhelmed with the sample bits for the BizTalk Server 2006 LOB adapters. If was often trial and error to figure out how to get the Oracle adapter working right, or figuring out how to do something specific with the Siebel adapter. Very few details or examples were provided.
That said, looks like the Connected Systems team is much more aggressively sharing information about the new [BizTalk] Adapter Pack. I just noticed a cornucopia of new code samples for the WCF LOB Adapter Pack. For each of the three available adapters (SAP, Oracle, Siebel), you’ll find samples for using the adapter with BizTalk, and, as a standalone WCF LOB adapter. The Oracle adapter has lots of examples that will prove useful (invoking functions, using cursors, executing select queries, etc). I also like that each adapter has a brief example of how to convert from using the BizTalk LOB adapters to the new Adapter Pack.
As part of my “BizTalk + WCF” series for TopXML.com, I’ll be demonstrating a few scenarios with the new Oracle adapter. These samples mean that I’ll spend less time punching myself in the head and more time building useful demonstrations.
Well done Microsoft.