Hi,

I want to write a DLL that will wrap a database's tables and records (with classes and properties respectively), but I don't know what is the best method to update the database when a record changes...

I guess I have 3 options:

1. Each class will have it's own recordset that points to the physical record on the DB (although this could be an important performance hit when there are thousands -or more- records)
.
2. Since each record has a unique id, I could store this id with each class, so when I need an update, I execute a "SELECT * FROM <table> WHERE <id> = <storedid>" and update the resulting record.

3. Create a general purpose function that will take as parameters the table name, the record id, and the columns with their values... And update the record accordingly.

What would be the better approach? Are there any other approachs?

Also, Is there a way to know when a record changes? This way I can cache the read records in memory, and update them only when the db changes...

Thanks in advance!