Edit Question - KnowledgeHub

Title Body

I'm using the SqlDependency class and have been trying unsuccessfully to find a list of possible combinations of the Type , Source and Info properties of the SqlNotificationEventArgs object. This is the closest I've found so far. However, I know this doesn't cover everything because I've already seen the combination Change/Client/Error. I'd really like to know if I'm handling all possible cases in the best possible way. That is, whenever possible I'd like to reestablish the "subscription". For instance the Change/Client/Error was do to a network issue that interrupted communication between SqlServer and my app. Once communication was reestablished I was able to recover successfully. EDIT: Maybe it would help if I gave some examples of the concerns I have. For the following questions when I say "recover" I mean reestablish a subscription at runtime, that is without manual intervention. Is it safe to assume that a Type of Subscribe means there is nothing I can do to recover. Is it safe to assume that a <a href="http://msdn.mic

Tags (comma-separated) Cancel