database watch

[ebco]

Like the FileSystemWatcher class to watch file do we have any method to watch sql database table(insert,update, delete) like what trigger doing of sql.

[Roelf]

yeah, we got triggers to take care of that.

you can create a trigger for a database table, look it up in the helpfiles or on google

a trigger can fire and do some actions on an insert, update or delete in the table its defined for

[ebco]

That is one solution from database point. I want entire solution from .net.

[Roelf]

i think i didn´t read your post well enough. Sorry

i dont know of any databasewatcher. i think it will be a pain to build one, much different types of databases, can´t watch changes on the db-file(s) because lot of things happen in memory before the changes are written to the file(s)

i think i would rely on triggers to watch for specific changes