none
SQL Cache Dependency ?

    Question

  • Does SQL Azure support SQL Cache Dependency (like the Microsoft Pet Shop sample)

    http://msdn.microsoft.com/en-us/library/aa479070.aspx

    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d MSPetShop4 -t Item -et
    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d MSPetShop4 -t Product -et
    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql -S localhost -E -d MSPetShop4 -t Category -et

    Friday, November 20, 2009 8:28 PM

Answers

  • Hello,
    From what I've seen up until now SQLCacheDependancy  is not supported on SQL Azure. Besides SqlCacheDependancy works by polling database for changes, which increases the generated traffic between your DB consumer application and SQL Azure. Well, it depends on the load over the application whether the polling will be generating more traffic or the actual data getting, but you can't use SqlCacheDependancy with SQL Azure. Yet. 
    But you can consider other ways of caching and invalidating cached data. You can still use the Cache object and fill it with data and you can use absolute expiration to invalidate cached Object.
    Saturday, November 21, 2009 9:24 PM

All replies

  • Hello,
    From what I've seen up until now SQLCacheDependancy  is not supported on SQL Azure. Besides SqlCacheDependancy works by polling database for changes, which increases the generated traffic between your DB consumer application and SQL Azure. Well, it depends on the load over the application whether the polling will be generating more traffic or the actual data getting, but you can't use SqlCacheDependancy with SQL Azure. Yet. 
    But you can consider other ways of caching and invalidating cached data. You can still use the Cache object and fill it with data and you can use absolute expiration to invalidate cached Object.
    Saturday, November 21, 2009 9:24 PM
  • Are there any plans to support this in SQL Azure? Thanks.
    Thursday, November 14, 2013 4:15 PM