monitor-table-change-with-sqltabledependency
monitor-table-change-with-sqltabledependency copied to clipboard
OnChanged doesn't work after some time
I have implemented Table Depedendy in my code. It works fine but after some time it does not work. It doesn't call the OnChanged event. I need to restart the application to make it work.
Is there any permanent solution to this problem?
SqlTableDependency<MyTable> _myTable = null;
_myTable = new SqlTableDependency<MyTable>(connectionString, "MyTable");
_myTable.OnChanged += OnChanged;
Version: 1.0.2.18