Chapter 8. The WCF-SQL Adapter and WCF Services

The current solution is a robust real-world scenario that does a good job demonstrating some basic capabilities of BizTalk Server 2010. We have orchestration, messaging, BAM, and unit tests. This chapter introduces the WCF-SQL adapter and how to use it to pull data from upstream systems as well as send data and requests to downstream ones. We will finish with how to expose WCF services from BizTalk.

Polling a database with the WCF-SQL Adapter

Our application is running well and it is now time to connect our solution to the site that receives sales orders from the web. This website uses a SQL Server backend to store sales orders. We must now automatically retrieve orders from the website's database ...

Get Microsoft BizTalk Server 2010 Patterns now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.