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
Subscribemeans there is nothing I can do to recover. - Is it safe to assume that a c# sql-server-2005 sqldependency