WCF LOB Adapter SDK and BizTalk Adapter Pack

The BizTalk Adapter Pack, comprising of the SAP, Siebel and Oracle WCF Bindings / Adapters which can be used with BizTalk Server 2006 R2. The Windows Communication Foundation (WCF) Line Of Business (LOB) Adapter SDK.

This Blog

Syndication

Search

Other Blogs Related to BizTalk Adapter Pack

WCF LOB Adapter SDK

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 decided NOT TO SUPPORT, they are:

SQL Server versions prior to SQL 2005.
The ability to perform one or more INSERT, UPDATE and DELETE operations, on one or more tables, all within the same XML message. In our current design, within a single message, you can either perform one or more INSERT, or UPDATE, or DELETE operations, all on the same TABLE or VIEW.
The ability to have multiple transactional blocks within the same XML message. All the operations within a message all take place within the same transaction; and this is actually a distributed transaction which spans these operations on your SQL Server, as well as the operations performed by BizTalk on the MessageBox database.

If any of the above are absolutely critical to your scenarios, please get in touch with us.

EDIT: Regarding the first two points, please have a look at this post.

Published Sunday, March 23, 2008 12:34 PM by mdoctor

Filed under: SQL

Comments

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Monday, March 24, 2008 8:17 PM

Hmmm, so will there be a way to perform multiple inserts in a parent-child situation within the same transaction? Say one parent to many children.

ThiagoAlmeida

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Tuesday, March 25, 2008 9:24 AM

Sounds good, looking forward to these changes. This is critical to a number of scenarios we use, however we have been using SQLXML updategrams to achieve this (using a standard SQL [adapter] SendPort). Is this likely to be very different?

Thanks

CGM

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Wednesday, March 26, 2008 4:10 AM

CGM, are you saying that having updategrams is critical to your scenario? The post mentions that we will not be supporting it ..

mdoctor

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Wednesday, March 26, 2008 4:15 AM

ThiagoAlmeida, if you're using SQL 2008, then you can create a Stored Procedure having table parameters - e.g., one table containing the parent rows, and one table containing all the child rows. Your stored procedure logic can then insert into the appropriate tables.

If you are using SQL 2005, then you have to take a slightly more laborious approach - you can create a stored procedure taking a single XML parameter, and you can invoke it with appropriately formatted XML values which can represent the parent-child hierarchy. Your stored procedure logic can then use the XML functions to extract various values.

mdoctor

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Wednesday, March 26, 2008 5:43 PM

Ah. Apologies, completely misread/misunderstood. It’s clear now.

Thanks.

CGM

# re: The new "WCF LOB Adapter SDK"-based SQL Adapter - Limitations @ Tuesday, April 08, 2008 5:22 PM

Thanks for the reply. I guess the 2005 method you mentioned can already be done with the current SQL Adapter, but it'll probably be easier with the WCF LOB one.