Using SqlDependency without providing an options value Error
Using SqlDependency without providing an options value Error. When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance. Using SqlDependency without providing an options value Exception. SqlDependency is awesome. It truly is. Problem is it has a lot of unexpected behaviors to an SqlDependency noob. I got this error: " When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance " couple of hours ago and I decided to share. This error occurs if you didn't started your SqlDependency or it got closed for some reason. I usually start it this way in the Global.asax : protected void Application_Start( Object sender, EventArgs e) { var sConn = ConfigurationMan...