title: Cache drop if query has WHERE Clause
body: <p>I am using SqlDependency and CacheManager class(Enterprise library Cachcing block) to create a cache in one of vb.net project. </p>
  
  <p>I have registerd </p>
  
  <pre><code>OnDependencyChanged(ByVal sender As Object, ByVal e As SqlNotificationEventArgs) 
  </code></pre>
  
  <p>method to get the notification back from Sql Server 2005. </p>
  
  <p>Now the problem is, if the query does not contains any WHERE clause then cache gets created successfully but if I add a where clause in my query then OnDependencyChanged() method gets notification as soon as cache is created. </p>
  
  <p>I need suggestion whether it is possible to have a WHERE clause in the query that is being used for caching. 
  My query is (with WHERE Clause):</p>
  
  <pre><code>SELECT [DATABASES_ID]  
        ,[DATABASENAME]
        ,[SERVERNAME]
    FROM [dbo].[DATABASES]
    WHERE datediff(dd,getdate(), [DATECREATED]) &lt;=0
  </code></pre>
  
  <p>Thanks
  Brijesh</p>