Enterprise library Caching with SQL Dependency in WPF

Topics: Caching Application Block
Mar 24, 2011 at 5:45 AM

How do I use enterprise library caching with SQL dependency in a wpf application

Mar 24, 2011 at 8:02 AM

EntLib's Caching Application Block has no builtin sql dependency expiration policy.  You would need to create your own by implementing the ICacheItemExpiration and the ICacheItemRefreshAction interface.  Refer here for more info on this.


Sarah Urmeneta
Global Technologies and Solutions
Avanade, Inc.

Mar 26, 2011 at 12:38 PM
Edited Mar 26, 2011 at 4:03 PM

SqlDependency seems to be making multiple calls to the OnDependencyChanged handler.

As I add more objects to watch for dependency, the callback increases exponentially.