Hopefully this is possible,

If I use Entity.EntityCollection.GetMultiAsDataTable() to get datatable, how can I return a possibly updated datatable to the Entity.EntityCollection?

Example:

 ' Get Customer  
    Dim Customer As New CustomerEntity(1) 

    ' Get Orders as datatable 
    Dim DT As DataTable = Customer.Wave.GetMultiAsDataTable(Nothing, Nothing, Nothing) 

    ' Some code to update the datatable 

    '  Some code to return the altered datatable to the entity

In short, I would like to get a datatable, update it, return datatable to entity, entity properties should now reflect the new values.

Is this possible?

Thanks,

csmith12 wrote:

Hopefully this is possible,

If I use Entity.EntityCollection.GetMultiAsDataTable() to get datatable, how can I return a possibly updated datatable to the Entity.EntityCollection?

Example:

 ' Get Customer  
    Dim Customer As New CustomerEntity(1) 

    ' Get Orders as datatable 
    Dim DT As DataTable = Customer.Wave.GetMultiAsDataTable(Nothing, Nothing, Nothing) 

    ' Some code to update the datatable 

    '  Some code to return the altered datatable to the entity

In short, I would like to get a datatable, update it, return datatable to entity, entity properties should now reflect the new values.

I think it's something like:

Dim customers As New CustomerCollection()
For Each row As DataRow In DT.Rows
    Dim newCustomer As New CustomerEntity()
    
    Dim i As Integer = 0
    For i = 0 to DT.Columns.Count-1
        newCustomer.SetNewFieldValue(i, row[i])
    Next
    
    customers.Add(newCustomer)
Next