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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.