Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Web service to update a database at a remote location

I have to update the database (machine is at remote location) from my local machine for my b2c Web project (ASP.NET) frequently. I planning to do it with a Web service by passing the dataset to the Web service as parameter. Is it the correct approach?
Datasets are appropriate when you are working with disconnected data as is the case in many network applications that retrieve database data, manipulate it then merge it back into the datastore. Datasets were designed to facilitate this pattern. Datasets are considered "too heavy" in situations where you are doing read-only access in particular when you are not caching the data. From what you've described, passing datasets seems like the right thing to do.
This was last published in April 2003

Dig Deeper on Application integration architecture



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.