SqlDependency throwing Invalid Operation exception
In our project we are invalidating the cache based on the change in the query output. This is implemented using change notifications.
In the Global.asax
file in the Application Start
block we have also added SqlDependency.Start(ConnectionStr)
. But still its throwing the following invalid operation exception:
Message "When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a co开发者_高级运维mmand added to the SqlDependency instance." string
What could be the possible reason for this issue?
精彩评论