How to implement UpdateBatch.. with XML DotNet

[ian mason]

How do I implement old ADO recordset.UpdateBatch method when using DotNet
XML?

The old XML seems to contain enough information to allow the UpdateBatch to
work when XML was sent to a middle tier.

I have looked at the XMLDataDocument and can load XML and a Schema (*.xsd) -
but the schema definition doesn't seem to have base tables and base columns.

I want to abandon ADO recordsets soon, but can't see how to move forward
other than to recode my servers so that they are aware of the type of data
being passed back for processing.

Am I missing something really obvious here?

 

[Mike Collier AdoAnywhere]

How do I implement old ADO recordset.UpdateBatch method when using DotNet
XML?

The old XML seems to contain enough information to allow the UpdateBatch to
work when XML was sent to a middle tier.

I have looked at the XMLDataDocument and can load XML and a Schema (*.xsd) -
but the schema definition doesn't seem to have base tables and base columns.

I want to abandon ADO recordsets soon, but can't see how to move forward
other than to recode my servers so that they are aware of the type of data
being passed back for processing.

Am I missing something really obvious here?

Ian, I had a similar situation myself. In the end I extended the XML
that was passed back to include enough information to perform updates.
As long as you can get basetable and basecolumns you should be ok. I
don't think the shape provider gives this information though..

You can try the generic SOAP Server from here
www.adoanywhere.com/soapyserver

If it does the updates that you need to do, let me know and I'll see
if I can dig out some more detail for you.

Mike.