Code Gallery BizTalk Samples : Steef-Jan Wiggers

Past few weeks I have contributed the following samples to MSDN Code Gallery:

• BizTalk Table Operations - Messaging

This sample will show how to perform simple table operations using WCF-SQL Adapter a part of BizTalk Server Adapter Pack. The Sample provided by Microsoft shows only Select statement operation. This sample will show all the other operations. It is based on the BizTalk Adapter Pack 2010 WCF-Custom with sqlBinding Table Operations through Messaging solution post.

• Polling SQL Azure Table - BizTalk Adapter Pack 2010

This sample will show polling a SQL Azure database table. It is based on Polling SQL Azure Database Table with WCF-SQL Adapter blog post.

• Sample - Table Operations on Oracle 11g XE with OracleDbBinding

This sample will show all the Oracle Table operations (in comparison with SQL, but there a few differences!). It is based on Table Operation on Oracle 11g XE with OracleDbBinding blog post.

• WCF-SQL Adapter Stored Procedure : SQL Azure

This sample will make use of BizTalk Adapter Pack as well and call Stored-Procedure in Azure. Sample is based on SQL Azure Stored Procedure blog post.

• ExecuteReader, ExecuteNonQuery, ExecuteScalar Operation with BizTalk Messaging

This sample will demonstrate three query operations through messaging in stead of using the WCF Service Model. BizTalk Server 2010 Adapter Pack Samples show only invoke ExecuteReader operation in SQL Server using ,NET. This sample shows all operations through messaging.

Cheers!