P
Paul W
I would appreciate any advice on best practice or better solution to the
following ...
I have a project where I retrieve a dataset from a webservice. I then use
writexml to persist the dataset to the Pocket PC CF or SD card. The data
will be manipulated over the course of several days before being sent back
to the SQL Server database. I am modifying data, accepting changes, etc...
with the dataset and using writexml frequently as a safe guard in case the
Pocket PC is reset or the battery dies. I do not want to use SQLCE for
various reasons, so I am opted to store the data on the Pocket PC as an xml
file. Once the data manipulation is complete, the dataset is sent back
using a webservice.
Currently, the webservice recieves the dataset and reads it table by table,
row by row and executes a stored procedure to update one row at a time in
the original SQL Server tables. I am only dealing with 4 tables and less
than 100 rows per table. The stored procedure takes the tables Primary Key
as an argument and overwrites all fields for that PK.
Is there a better way to update the SQL database?
following ...
I have a project where I retrieve a dataset from a webservice. I then use
writexml to persist the dataset to the Pocket PC CF or SD card. The data
will be manipulated over the course of several days before being sent back
to the SQL Server database. I am modifying data, accepting changes, etc...
with the dataset and using writexml frequently as a safe guard in case the
Pocket PC is reset or the battery dies. I do not want to use SQLCE for
various reasons, so I am opted to store the data on the Pocket PC as an xml
file. Once the data manipulation is complete, the dataset is sent back
using a webservice.
Currently, the webservice recieves the dataset and reads it table by table,
row by row and executes a stored procedure to update one row at a time in
the original SQL Server tables. I am only dealing with 4 tables and less
than 100 rows per table. The stored procedure takes the tables Primary Key
as an argument and overwrites all fields for that PK.
Is there a better way to update the SQL database?