|
|
| | |
Problems with SqlCacheDependency
Posted: 03 Dec 08 6:44 AM (Canada) |
| | |
Has anyone managed to get a SqlCacheDependency working properly?
The training kit doesn't have alot of details, but I'm going through the steps outlined in the Asp.Net 2.0 Core Reference and I'm not able to make the cache expire by changing the database values.. (the cached value expires after the specified time, I just can't force it to expire before that via the database...)
I'm just wondering if anyone else ran into difficulties getting this to work.. I plan to come back to it after doing some googling, I just wanted to know if anyone else had problems or whether I'm missing something not outlined in the book.. (Like for example, how you have to use fully-qualified table names and query for specific attributes with the SqlCommand object..)
Note: I'm working with SQL Server 2005 and using the SqlCommand object to build the dependency. |
| |
| | |
Re: Problems with SqlCacheDependency
Posted: 12 Dec 08 1:11 PM (Canada) |
| | |
| I ended up being able to get this to work. I thought I had enabled the database for caching, but when I noticed there weren't any cache stored procs, that was my clue. |
| |
| |  .NET Development MCTS 70-528 Study Group Problems with SqlCacheDependency |
| |
| | | |