BizTalk Server Adapter Pack 2010: WCF SQL Adapter
Introduction
The WCF based SQL Adapter can be used to connect BizTalk applications to SQL Server. WCF-SQL Adapter is part of BizTalk Server Adapter Pack 2010. To work with the adapter you will need to install the BizTalk Server 2010 Adapter Pack before installing this adapter (Adapter Pack is available through BizTalk Server 2010 medium e.g. DVD/ISO). This article will provide you the necessary resource links to find information on the BizTalk WCF-SQL Adapter, how to work with it and so on.
Blogs/TechNet Wiki
The following blog posts and Wiki articles provide you more background information on WCF-SQL Adapter, how to install it, use it, and so on:
- Installing BizTalk Adapter Pack 2010 on x64
- WCF-SQL Adapter Table Operations
- WCF-SQL Adapter Stored Procedure
- Debatching Inbound Messages from BizTalk WCF SQL Adapter
- New SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter
- Using FOR XML queries with the WCF-SQL Adapter
- Typed Polling with WCF-SQL Adapter: Best Practices and Troubleshooting Tips
- BizTalk Server: WCF-SQL Adapter Table Operations
Code Samples
Through MSDN Code Gallery and download center you can find a number of code samples:
Other languages
This article is also available in the following languages
See Also
Read suggested related topics:
- BizTalk Server Adapter Pack 2010
- Microsoft BizTalk Adapter for SQL Server Help
- BizTalk Server: WCF-SQL Adapter Table Operations
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.