Question: web service updating data

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

I am creating a web service that gets, as an input argument, a dataset. It
takes this dataset and updates a local database.

I'm familiar with ADO, but ADO.NET is kind of new to me. Do I have to
manually loop through every record in the incoming dataset, updating the db
one row at a time, or is there a simple 'update' command which is smart
enough to know which records to update?

Thanks,
Robert
 
Hi,

Using a tool like nTierGen.NET (http://www.nTierGen.NET/), it is as simple
as:

myOrderDS = new OrderDAO().Persist(myOrderDS);

This works for multi-tabled DataSets too. Also, getting data is as easy:

myCustomerDS = new CustomerDAO().GetByCustomerID(344);

or

myCustomerDS = new CustomerDAO().GetAll(PageNumber, PageSize);

Take a look at http://www.ntiergen.net/samples/contacts/ for a sample
application.

Thanks,
Gavin Joyce
www.gavinjoyce.com

--
___________________________________________________________
nTierGen.NET Code Generator - http://www.nTierGen.NET/

Stored Procedures (Get, GetPaged, Insert, Update, Delete)
Data Access Layer - C#
Business Rules Layer - C# & VB.NET
Strongly-Typed DataSets - C#
Web Services - C#
___________________________________________________________
 
Back
Top