I have a VS 2008 app with a SQL Server 2008 database that I want to communicate with a customer's legacy system. To simplify my question, let's say it's an inventory application.
My system handles receipts, issues and inventories. I update my inventory and transaction tables according to the type of transaction. For example, if it's a receipt, I increment my inventory level (or create a new record if the item is not already in inventory) and I add a record to the transaction table.
My question is: Would it be better to have specific web services for all transaction types (receipt, issue and inventory) where I only pass the data fields needed or would the web services simply handle inserts, deletions and updates and I would pass my entire dataset and let the web service determine how to handle each transaction.