WCF LOB Adapter SDK and BizTalk Adapter Pack

Using the WCF SQL Adapter to submit messages to SSB queues from BizTalk

This post is a follow-up to http://blogs.msdn.com/adapters/archive/2008/06/30/using-the-wcf-sql-adapter-to-read-messages-from-ssb-queues-and-submit-them-to-biztalk.aspx and explains how to push a message using the WCF SQL Adapter from BizTalk to a SQL Read More...

Posted Wednesday, October 07, 2009 5:11 AM by SandeepP | 0 Comments

Multiple ways to Poll (Receive Location in BizTalk) in the SQL Adapter

In this post, I outlined the ways in which stored procedures can be executed using the SQL Adapter. Similar to the methods described there, are very similar methods for polling on the inbound side. (I won’t mention the advantages/limitations/workarounds Read More...

Posted Monday, October 06, 2008 6:53 PM by mdoctor | 3 Comments

Multiple ways to generate metadata / execute Stored Procedures in the SQL adapter

If you’ve used the SQL Adapter in CTP3 of the BizTalk Adapter Pack V2, you’ll notice that there are two nodes in the Metadata Hierarchy for Stored Procedures – one is named “Procedures”, and the other is named “Strongly-Typed Procedures”. What’s the difference, Read More...

Posted Tuesday, September 30, 2008 12:05 PM by mdoctor | 0 Comments

Using the WCF SQL Adapter to read messages from SSB queues and submit them to BizTalk

In this post, I’m going to demonstrate how the Polling feature in the WCF SQL Adapter can be used to read messages from SQL Service Broker (SSB) queues and publish them in the BizTalk MessageBox. And to make it really simple, we’re going to do it without Read More...

Posted Monday, June 30, 2008 3:58 PM by mdoctor | 0 Comments

Address should be unique for Receive Location – error when creating a Receive Location in BizTalk

Assume you’re using the WCF SQL Adapter (part of the BizTalk Adapter Pack 2.0). You decide to create 2 Receive Locations (RL), in order to poll the database. Each RL polls a different table (e.g., the “PollingStatement” binding property in the first RL Read More...

Posted Saturday, June 28, 2008 7:40 AM by mdoctor | 0 Comments

The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations

As mentioned in this post, we're developing a new SQL Adapter, which will be available in the next release of the BizTalk Adapter Pack. The list of features which we're supporting is mentioned in that blog post. As for the features/items/etc which we've Read More...

Posted Sunday, March 23, 2008 12:34 PM by mdoctor | 6 Comments

The new "WCF LOB Adapter SDK"-based SQL Adapter - Features

The current release of the Adapter Pack contains the SAP, Siebel and Oracle adapters (written using the WCF LOB Adapter SDK). For the next release of the Adapter Pack, one of the adapters which we're adding is a SQL Adapter. Some of the features which Read More...

Posted Monday, February 04, 2008 5:00 PM by mdoctor | 6 Comments

Getting LOB metadata from SAP, OracleDB and Siebel adapter using svcutil

The WCF based adapters that ship in the Biztalk Adapter Pack are WCF bindings. The svcutil tool can be used to get metadata for a LOB method using these bindings. The scheme in the URI determines which adapter binding is loaded by svcutil. However when Read More...

Posted Tuesday, October 23, 2007 9:56 AM by Jayanthi S | 2 Comments

Attachment(s): svcutil.exe.config