XML Structure Tab: XML Schema Column

This column displays the same information available in the XML Schema pane on the Mappings tab. On the XML Structure tab, you need the schema information to identify which nodes to combine and sort in the XML output. When a node is displayed with a key icon, the node is mapped to a primary key in the database.

Example

 

 

Marshal with Combine Project

Overview of the project used in examples below.

1.

Marshal Without Combine

No settings have been made in the XML Structure tab

2.

Marshal with Combine

XML output combines all PurchaseOrder nodes that have a matching value for the OrderID node.

3.

Marshal with Combine and Group

 XML output groups  all matching elements (LineItem) together

4.

 

Marshal with Combine and Order By

XML output contains records retrieved from the database using an ORDER BY clause

5.

Marshal with Optimized Combine

XML output generated using the Optimized Combine feature in the XML Structure tab.

See Also

XML Structure Tab
Introduction to Combining Nodes in XML Output When Marshalling

Combining Duplicate Elements in XML Output

Customizing Combine Settings for XML Output