UPDATE: I have since moved these articles to my own blog and they can be found here.
So how would you use the BizTalk Adapter Pack to build a RESTful HTTP URI on top of an Oracle database table? What about calling Oracle stored procedures that made use of either strong or weak ref cursors? In my latest article for TopXML.com, I explore how to consume the Microsoft BizTalk Adapter Pack’s Oracle adapter using the WCF service model.
Specifically, I show how to …
- Insert multiple records into an Oracle table using a single WCF operation call
- Call Oracle stored procedures and process their result sets in either a strongly typed or weakly typed fashion
- Using the adapter’s “polling” mechanism to build an Oracle database polling WCF host
- Apply RESTful WCF attributes from the .NET Framework 3.5 to the BizTalk Adapter Pack
This was a fun article to write. The ability of the adapter to poll an Oracle database and kick off an event introduces a number of possibilities. Also, applying some of the things that I had read about the new RESTful WCF attributes with the auto-generated Oracle adapter bits proved to me a useful exercise.
Feedback? Let me know.