title: SqlCacheDependency not working
body: <p>I would like to add SqlCacheDependency to my app. 
  So I desided to create littel tesp project and confronted with difficulties.
  I use MSSQL 2008. I create new db with table Lines and added several rows.
  I executed:</p>
  
  <pre><code>ALTER DATABASE ForTest SET ENABLE_BROKER 
  </code></pre>
  
  <p>in managmeng studio. </p>
  
  <p>Aspx page:</p>
  
  <pre><code>public partial class WebForm1 : System.Web.UI.Page
    {
      protected void Page_Load(object sender, EventArgs e)
      {
        if (!IsPostBack)
        {
         if (Cache["Lines"] == null)
         {
           string connectionString = 
             WebConfigurationManager.ConnectionStrings["ForTest"].ConnectionString;
           SqlConnection con = new SqlConnection(connectionString);
           string query = "SELECT dbo.Lines.Id, dbo.Lines.Value FROM dbo.Lines";
           SqlCommand cmd = new SqlCommand(query, con);
           SqlDataAdapter adapter = new SqlDataAdapter(cmd);
  
           DataSet ds = new DataSet();
           adapter.Fill(ds, "Lines"); 
  
           SqlCacheDependency empDependency = new SqlCacheDependency(cmd);
           Cache.Insert("Lines", ds, empDependency); 
         }
        }
      }
  
      protected void btnResult_OnClick(object sender, EventArgs e)
      {
        var result = Cache["Lines"];
      }
  }
  </code></pre>
  
  <p>I run this page and add lines to Cache then I add row in managment studio and when I click on button I expect
  that the cache will be changed but cache remains old. 
  I can't find what I do wrong :( Could you give me some hint how I can solve this problem?</p>
  
  <p>Thanks</p>
  
  <p>Update: 
  I forger to say that in global.aspx I run:</p>
  
  <pre><code>SqlDependency.Start(
      WebConfigurationManager.ConnectionStrings["ForTest"].ConnectionString
  );
  </code></pre>