sqlcachedependency

Has anyone worked on caching?

Is there anyone who can answer my questions on SqlCachedependency Cache Invalidation Query Notifications etc etc etc ...

Can We use SqlCacheDependency with a product not containing ASP.net part?

Is SQLCacheDependency used in context of ASP.net or can it be used for a project of .net only. Rather tahn using ASP.net i am receiving request by listening on a port.I want to store data for my session in cache.If this data is fetched from database then i want it to be updated using something like SQLCacheDependency.Can I configure it f...

Is a notification registered in SQL Server for a failed SqlCacheDependency's SqlCommand ExecuteScalar?

We have some code that hits our SQL Server 2005 database via LINQ to SQL to read a list of objects from a table, converts them to our serializable middle tier version of the objects, then caches that list using an SqlCacheDependency. However, at several times throughout the day, a large update on the underlying table occurs which seems...

Enabling Service Broker in SQL Server 2008

Hello, I am integrating SqlCacheDependency to use in my LinqToSQL datacontext. I am using an extension class for Linq querys found here - http://code.msdn.microsoft.com/linqtosqlcache I have wired up the code and when I open the page I get this exception - "The SQL Server Service Broker for the current database is not enabled, and a...

T-SQL Emitted by the aspnet_regsql.exe when working wih Sql Cache Dependency

Hi All, Recently our application went for Load Testing and in the profiler trace of out DB we found out that the T-SQL emitted by the aspnet_regsql command ran for more than 341 times, whereas it must only for the creation of the Notification table and the SPs it uses for reading and writing values into this table. Does anyone have any ...

Asp.net sql cache dependency programmatically configuration

Hi everybody, I've a question regarding SqlCacheDependency configuration. Every resource I've read requires the developer to define the polled databases into web.config. This is not a good scenario for our application that connects to different databases, because we don't want to edit web.config each time we add / remove a database. We ...

Caching paged LINQ results without using Skip() or Take()

I am using LINQ for paging data in my website. I am currently using Skip() and Take() to perform the paging. Now I want to cache the data using cache dependencies so that the the cache will invalidate if the data changes. However SQL Server's query notifications don't support the TOP expression. Are there any alternative ways to query a ...

SqlCacheDependency leads to lots of queries to my db

I have implemented my own SqlCacheDependency public SqlCacheDependency CacheControllerDependency(CacheControllerKeys cacheKey) { SqlConnection conn = new SqlConnection("connection"); try { SqlCommand command = new SqlCommand( @"SELECT [CacheName] ,[CacheReloadDate] ,[CacheRelo...