IsNemoEqualTrue/monitor-table-change-with-sqltabledependency

OnChanged doesn't work after some time

viveknuna opened this issue · 0 comments

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