Microsoft BizTalk Server 2010 Patterns

Performing imperative queries with the WCF-SQL Adapter

The WCF-SQL Adapter can also be used for send ports and performing imperative queries, rather than just polling read operations, like we just accomplished. Our AlphaSales database also contains customer information that we, and other teams in the enterprise, are interested in accessing. We are asked to create a customer WCF service for accessing this information. Like always in BizTalk solutions, we will use a canonical schema to provide isolation and decoupling. To accomplish this, we must perform the following steps:

1. Create WCF-SQL endpoint schema
2. Create an external schema to expose as a service
3. Create an internal, canonical schema to build our solution
4. Create maps to tie the schemas together ...