BizTalk Blog by Chris Han

System Design for Enterprise Agility,

  Home  |   Contact  |   Syndication    |   Login
  68 Posts | 9 Stories | 173 Comments | 79 Trackbacks

News

Article Categories

Archives

Post Categories

Image Galleries

BizTalk Bloggers

BizTalk on MSDN

Patterns & Architecture

SharePoint

Populate multiple tables in a parent-child relationship in one roundtrip (Inserting Data by Using XML Updategrams)

The other great post by Stephen Kaufman is this indeep 'Using SQLXML's at-identity with BizTalk'

http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx

To me that's not only explain a way to do this thing, but also some inside information about SQL adapter. So that I know how to cmpare the implementation between using SQL adapter or a custom ADO.NET DAC to insert data to the SQL server.

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
posted on Monday, April 10, 2006 2:20 PM

Feedback

# re: Populate multiple tables in a parent-child relationship in one roundtrip (Inserting Data by Using XML Updategrams) 7/1/2009 8:44 PM Rajashekar
I have scenario where I need to insert into child table only for special type of header record.
When I tried the solution provided It didn’t work, since child record is blank it throws exception.

HRESULT="0x80070057" Description="Invalid Argument"
<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80070057" Source="Microsoft OLE DB Provider for SQL Server" Description="Invalid Argument"?></Root>

Do we have a solution for this kind by using UpdateGram or we need use Stored Procedure ?

Thanks,
Rajashekar


Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: