working with one to many relationship in web service

[Chad]

I am new to web services and biztalk, but I recently created an orchestration
to handle a purchase order approval process. I used biztalk to publish the
orchestration as a web service. My goal is to access all of the properties
of the request...date, delivery date, vendor info and purchase items through
a custom web interface I have developed. My hang up is how to work with
purchase items since it has a one to many relationship to the request itself.
Does anyone have suggestions on how to build that "set of data" and return
it to the code behind in my web project? Is there a way to build it as an
array, collection, dataset???

The autogeneration of the web service classes look like this for purchase
items...
public class POResponsePurchaseItemsPurchaseItem
{

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.UInt32 Quantity;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public string PartNumber;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public string Description;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.Decimal UnitCost;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.Decimal ExtendedCost;
}

Where purchase items are a node of the requisition and each purchase item is
inside purchase items.

Thanks in advance for any help.

[erymuzuan]

The best practice for designing web services is always rely on schema
for contracts, not type. So use element or complex type and set the
maxOccurs to unbounded. Never do dataset.
regards
erymuzuan

Chad wrote:

I am new to web services and biztalk, but I recently created an orchestration
to handle a purchase order approval process. I used biztalk to publish the
orchestration as a web service. My goal is to access all of the properties
of the request...date, delivery date, vendor info and purchase items through
a custom web interface I have developed. My hang up is how to work with
purchase items since it has a one to many relationship to the request itself.
Does anyone have suggestions on how to build that "set of data" and return
it to the code behind in my web project? Is there a way to build it as an
array, collection, dataset???

The autogeneration of the web service classes look like this for purchase
items...
public class POResponsePurchaseItemsPurchaseItem
{

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.UInt32 Quantity;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public string PartNumber;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public string Description;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.Decimal UnitCost;

/// <remarks/>

[System.Xml.Serialization.XmlElementAttribute(Form= System.Xml.Schema.XmlSchemaForm.Unqualified)]
public System.Decimal ExtendedCost;
}

Where purchase items are a node of the requisition and each purchase item is
inside purchase items.

Thanks in advance for any help.