title: SqlDependency Not firing c#
body: <p>Hi I am trying to implement Sql Dependency into my windows service code. I have already set my service broker as true. I have written this code inside Windows On Start method. The method OnDependencyChange should start as soon as there is new entry in table. But it never happens.
  Here is my code,</p>
  
  <pre><code>        System.Data.SqlClient.SqlDependency.Start("connection 
          string;database=dbName;Integrated Security=True;");
          SqlConnection connection = new SqlConnection("connection 
          string;database=dbName;Integrated Security=True;");
          connection.Open();
          using (SqlCommand command = new SqlCommand("SELECT * FROM 
           UserDetails", connection))
          {
  
  
              SqlDependency dependency = new SqlDependency(command);
  
  
  
              dependency.OnChange += new
                 OnChangeEventHandler(OnDependencyChange);
  
  
              using (SqlDataReader reader = command.ExecuteReader())
              {
                  // Process the DataReader.
              }
          }
  
  
  
       void OnDependencyChange(object sender, SqlNotificationEventArgs e)
       {
        // Handle the event (for example, invalidate this cache entry).
       }
  </code></pre>
  
  <p>Please help.</p>