Precisely, a VFP application using FP Tables will prepare a set of cursors for this process. I have been advised that the "Best Practice" approach for this application would be to FTP the cursors to the remote server and use the FileSystemWatcher component to raise an event which would be handled by a process on the server. I was even thinking of applying the updates directly from the desktop systems but after consideration of volumes thisnk that this approach will be inneficient.

Regarding volumes, I expect record update volumes to be typically 0 - 200 records. However there will be occasion where 20,000 records will need insertion or update.

In any case I have been studying my ADO.Net books and my "VB.Net and SQL Server 2000" book and find no examples of batch updating like this. I know that it is done every day, but unfortunately I do not know how to code the "Update" statments in ADO.Net or how to approach this problem in this environment. If this were a VFP app my choice would be FTP with a watchdog program and use a correlated "Update SQL" syntax for the updating.

So what I am asking is

• What would you suggest as "Best Practice"
  
• How to code my Inventory BO to apply the
  • Inserts
  • Updates
  • Deletes
  
  
• Advisability of using MM.Net BO's for this project
  
• If MM.Net is used
  • Create BO's for the Transactions
  • Creeate independent Connections and Datareaders for the transactions
  
  
• And finally should I "chuck" the whole thing and join a Lobster boat crew?
  
  I feel very frustrated and uneasy NOT knowing how to do something after so many years of adequate skills, but I am sure that this is common when learning new paradigm.
  
  Thanks
  
  
  >>This is a new application which is both for production and as a test of the usefulness of .Net. I have been experimenting with MM.Net and hope to use the framework for this application. My initial thoughts were to use a VFP COM server to prepare the data forr further processing on the WEB server. Store VFP generated XML to Datasets and then use MM.Net to safely tuck them away on SQL Server where a stored procedure would "digest" the VFP data.
  >>
  >>I would appreciate any comments or "Best Practices" recommendations for this application. We are VERY serious about adopting MM.Net for future development and integration into our flagship product, and I need to develop adequate skills to promote .Net interop.
  >
  >You said the VFP desktop app prepares a batch of inventory updates. Where is it getting the inventory update information from? Are FoxPro tables involved in the mix? It sounds like you're thinking of converting cursors to XML and passing them to a web server running a .NET Web Service which would in turn write the updates to SQL Server?
  >
  >Regards,