I have created a WPF program that shows some data drown by SQL from the network (using linq2sql). I am using SqlDependencyEx to track changes or additions to that data and refresh my view accordingly.
However, if the network is interrupted for some reason, SqlDependencyEx drops the connection and when the network comes back, the view no longer refreshes with the new data.
Is there a way to know that the connection is back, so i can refresh my view and restart SqlDependencyEx instances?