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:
- Create WCF-SQL endpoint schema
- Create an external schema to expose as a service
- Create an internal, canonical schema to build our solution
- Create maps to tie the schemas together ...
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.