Updating Tables Using a Single Updategram Message in BizTalk Server 2004 and 2006
page 5 of 8
by Naveen Karamchetti
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 35491/ 70

Creating Updategram

Observe the following XML structure.

Listing 3 – Updategram XML structure

We would need to generate a schema in such a way so as to map the XML structure shown in Listing 3. Notice the attribute at-identity. This denotes that the value for the identity column which gets generated (when the Publisher row is inserted) shall be picked up by the Book; notice the attribute PublisherID in the Book element.

The value of the at-identity and the PublisherID shall be "NewID."

There are two different namespaces referred to in the above XML document, one is the "ns0" namespace and another one is the "ns1" namespace for the updategram.

Creating Schema for the "at-identity" attribute

Listing 4 – Root schema structure for the attribute 'at-identity'


Observe the schema in Listing 4, the target namespace for the attribute is the updategram.

Figure 1 – The completed schema structure for the updategram

This schema references the attribute schema created in Listing 4.

The schema in Figure 1 would generate the XML structure specified in Listing 3.

Mapping to the datagram

This map is used to map the incoming messages to the updategram schema. In this case the book and publisher messages are mapped to the updategram schema.

Figure 2 – Mapping messages to datagram schema

View Entire Article

User Comments

Title: Insert in to multiple tables at a time.   
Name: Umesh
Date: 2008-11-27 8:20:12 AM
Hi ,
I want to insert data in multiple tables at a time (like header and details ) .
for this purpose i am using Updategram.How can i generate schema for this purpose.

Title: Getting invalid namespace error with above sample   
Name: Krishna Sharma
Date: 2007-12-04 6:37:55 AM
I am getting "Invalid Schema" error in the send port while inserting data. any help..If you have sample code .plz send
Title: How to update multiple tables   
Name: Gopal
Date: 2007-11-26 10:54:19 PM
Above information only tells how to insert into multiple tables, I am trying to update multiple tables could not succeed... I did not find any information on updating multiple tables....


Error details: HRESULT="0x80004005" Description="All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id"

Can some one point me in right direction...

Thanks in advance

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-02-25 7:41:23 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search