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

Code Samples

Through MSDN Code Gallery and download center you can find a number of code samples:

• BizTalk Adapter Pack 2010: SQL Adapter Samples
• BizTalk Table Operations - Messaging

See Also

• BizTalk Server Adapter Pack 2010
• Microsoft BizTalk Adapter for SQL Server Help

Other languages

This article is also available in the following languages

• Norwegian: BizTalk Adapter Pack 2010 - WCF SQL Adapter (nb-NO)