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 ...