I have used sql server service borker notification service and queue for my .Net application (windows service) to get query notification when any update in query(table).
in application i have used sqlDependency to get query notification on change.
this service and queue is working fine and i am getting query notitication in application.
In window service there are many (50 or more) sql operation perform in 1 seconds. if i am using sql server service broker,
i was getting SQLException like :
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is open.
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
if i disable borker and delete service/queue, then everything working fine (no sql exception)
Question : does Service borker caues sql server performance issue with connection from C# ?
if you need sample then will provide sample how i have implemented service borker in .Net application.
it would be great if you provide any solution for this.