none
Service Broker causes SqlExceptions

    Question

  • Hello,

    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.


    Thanks in Advance.
    Thursday, August 14, 2014 2:09 PM