Question How can I track changes to a database table

[mgjaltema]

Hello!

I hope somebody can help me. I have a MS SQL database with multiple tables, where one of the tables is really important. I have several clients simultaniously working with this table and the data should be consistent between the clients.

How can I make sure all my clients no that data in the table has changed. I'm preferring a "push" meganism instead of using a timer to pull the table... Who has done this before and can help me with trics or samples?

Thank you very very very much!

Marcel

 

[jmcilhinney]

There is no simple option. It has to be something initiated by the client because the server doesn't know who all the clients are. If the number of clients is small then you might look at the SqlDependency class. I've never completed an implementation so I can't give you the details, so you should start by reading the documentation and then look for examples.