Jon and Time
Thank you for your suggestions.
Yes, the abstraction layer will work for both the main database and the metadata cache database. A method that deletes all data associated with a given serviceID, siteID or variableID will be included.
The abstraction layer is getting ready. Before it is released the following decision needs to be made:
A) Use the very generic object model proposed by David Valentine and make some modifications to the existing HydroDesktop database schemas.
B) Use a simplified object model more compatible with the current HydroDesktop database schema.
My vote is for B) but the Cuahsi team should decide.