My latest deep-diving has been on the SqlCacheDependency class in System.Web.Caching. It is the first time I've messed with caching at the web service level to handle lookups to SQL Server. Luckily, I'm using SQL Server 2005, so I should be able to bypass some of the older methods of hooking into the updates. Mainly, it appears the Service Broker in SQL Server handles most of the work. Nice!
We'll see how the wire-up goes. So far, it's a bit confusing on how to lazy load the cache with specific pieces of information. I'll post more later.
No comments:
Post a Comment