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.
| Series Summary | |
| BizTalk and WCF: Part I, Operation Patterns | Get the source code! |
| BizTalk and WCF: Part II, Security Patterns | |
| BizTalk and WCF: Part III, Transaction Patterns | |
| BizTalk and WCF: Part IV, Attachment Patterns | |
| BizTalk and WCF: Part V, Publishing Operations Patterns | Source code coming soon! |
| BizTalk and WCF: Part VI, Publishing Advanced Service Patterns | |
| BizTalk and WCF: Part VII, About the BizTalk Adapter Pack | |
| BizTalk and WCF: Part VIII, BizTalk Adapter Pack Service Model Patterns | |
| BizTalk and WCF: Part IX, BizTalk Adapter Pack BizTalk Patterns | |
RSS Feed
0 Responses to “Article Series on BizTalk and WCF: Part VIII, BizTalk Adapter Pack Service Model Patterns”