Today I found a class in the .net framework which makes it possible to get events about data changes of a sql server table (idea of a trigger, but outside the db in a higher layer) what is perfect for caches: SqlDependency. Internally it uses the service broker of the sql server what sounds quite reliable in comparison to watch dogs. (About 2 years ago I made such a watch dog framework,... my experience: don't do that...)
kr,
Daniel
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx
http://stackoverflow.com/questions/5288434/how-to-monitor-sql-server-table-changes-by-using-c
https://github.com/dyatchenko/ServiceBrokerListener
kr,
Daniel
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx
http://stackoverflow.com/questions/5288434/how-to-monitor-sql-server-table-changes-by-using-c
https://github.com/dyatchenko/ServiceBrokerListener
No comments:
Post a Comment