.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SqlCacheDependency, SQL Notifications, and Cache Expiration

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :ASP.Net
I've spent the last few days trying to get caching working with my C# ASP.NET web application and SQL Sever 2005.  I'd like to take advantage of row-level caching by using a SqlCacheDependency on the SQL command used to fetch the row of data.  However, I can't seem to get it to work.From a high level I can retreive my data fine, get it into the cache, and then retrieve it just fine.  However, when the data is modified in the database, the cached object does not expire.  The best I can tell is that there are no SQL Notification subscriptions that are set up.  It appears that the broker service is set up on the database and I can see a SqlQueryNotificationService in the Queue and Services.  There don't seem to be any errors in the SQL log that I can find either.To set everything up on my database I did the following:Made sure that ENABLE_BROKER was set on the database (select is_broker_enabled from sys.databases where name = '<dbname>' returns 1)Set privaleges for my database user properly with:GRANT CREATE PROCEDURE TO <dbuser>GRANT CREATE QUEUE TO <dbuser>GRANT CREATE SERVICE TO <dbuser>GRANT SUBSCRIBE QUERY NOTIFICATIONS TO <dbuser>We typically use a data access layer for accessing our data, however, I wanted to test a stupid simple example of caching when I found I couldn't get it to work.

View Complete Post

More Related Resource Links

AppFabric Cache: Real-World Usage and Integration


Windows Server AppFabric provides a distributed cache for both web and desktop applications. Well show you how to integrate AppFabric caching into your apps, along with some hints for taking advantage of new cache features in the .NET Framework 4.

Andrea Colaci

MSDN Magazine June 2010

Foundations: Dependency Properties And Notifications


Windows Presentation Foundation dependency properties don't always play well with others. Learn how you can compensate for their lack of notification events.

Charles Petzold

MSDN Magazine September 2008

Security Briefs: Active Directory Cache Dependencies


If you're not taking advantage of Active Directory, you should be. Learn the benefits from Keith Brown.

Keith Brown

MSDN Magazine July 2007

Cutting Edge: Implement Custom Cache Dependencies in ASP.NET 1.x


One of the most compelling improvements that ASP. NET brought to ASP programming was the Cache object. The Cache has some similarities to the Application object and is a container of global data (as opposed to session-specific data) that features a fair number of innovative characteristics.

Dino Esposito

MSDN Magazine July 2004

Wicked Code: Supporting Database Cache Dependencies in ASP.NET


Developers love the ASP. NET application cache. One reason they love it is that ASP. NET lets them create dependencies between items placed in the cache and files in the file system. If a file targeted by a dependency changes, ASP.

Jeff Prosise

MSDN Magazine April 2003

Basic Instincts: Implementing Callback Notifications Using Delegates


Delegates are a critical aspect of the Microsoft® . NET Framework and are required learning for many programmers. They will take some time to master, but once you learn how to program with delegates, you'll be thrilled with the possibilities they offer.

Ted Pattison

MSDN Magazine December 2002

How to Cache System.Collection.Generic.List object


I need to cache System.Collection.Generic.List object with expiration time

var Root = from feed in feedhotel.Descendants(ota + "HotelContent")
                           where (feed.Attribute("HotelCode") != null)
                           select new xmlhotel()




return Root.ToList();

Is it possible to cache Root.ToList() for some time....




I am trying to use SqlCacheDependency in my web site.

I got in touch with my hosting compnay and they said that they support cache but they set the trust level to medium and what I try to do needs full trust level whihch they cannot provide for me.

can someone show me a way or a code samples that use SqlCacheDependency with medium level trust?

the broker is enabled in the hosting sql server 

this code raise the error that the hosting providers said that they cannot support in medium level:


I have the tables needed in my developer SQL server , but I don't know how or if I can set it in the hosting SQL server db

and this is my code to get the data from cache or from DB that works on my developer station:

If Cache("allitems") Is Nothing Then
      Using dcdc As New DataClassesDataContext()

Force password expiration after x days


Using C# and sqlmembershipprovider forms authentication, is there a way to force user password to expire and need to be reset after x number of days?

So if a user launches the website login.aspx page, when they type their userid, it will check if the password is expired and direct them to a Resetpassword.aspx page?

Blog site Restrictions -- How to set an expiration date on blog posts

I just created a new Blog site in Sharepoint 2007, and set permisions to the users and admins.
Now, I have a question on how to set the post life time. Is there any setting to contral how many days that the posts can last in the blog? We want the post include the comments kept in the site for one month.

Please help.


How to clear cache


We have an ASP.NET-based print tool that will create a printable version of a webpage (as a PNG, I believe). The URL is something like:


which is displaying an older version of the webpage.

The URL to just the webpage displays the current version:


Observations so far:

  • I've deleted temporary Internet files on clients, which had no effect.
  • The behaviour is the same on different clients, which suggests a server issue.
  • I've requested that the temporary ASP.NET files are deleted from:
    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\mysite_tools_printfromweb
    (It's a customer's web server. I've checked the version of ASP.NET associated with the tool.)

So, my questions are:

Am I right in thinking this is probably a caching issue, and are there any other locations and/or settings I should be looking at?

With thanks.

Problem insert POCO to Velocity Cache



I want to put POCO object to Velocity cache. How can I serializable ICollection to Velocity cache, or exclude ICollection from serialization?

I got this exception

Type 'System.Collections.Generic.ICollection`1[Model.Collection]' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute.  If the type is a collection, consider marking it with the CollectionDataContractAttribute.  See the Microsoft .NET Framework documentation for other supported types.



output cache to be used only when parameter has changed + old question of user control not answered



i have 2 questions about output cache:

1.is it just me , or does it seems that it is used only after the second time that the user reaches the webpage? if so, why, and how can i tweak it to my needs? my guess is that it wouldn't be logical to cache every time a user reach a webpage, but only when it happens enough times.

2.i know that i can use "varybyparam" for using the output cache when the parameter doesn't change , but it seems that it would use the output cache even if there is no parameter , or if the specified paramter is not there. is there a way to overcome this?

3.an old question that somehow marked as "answered" , yet i didn't solve : suppose i created a user control and i gave it values through the CTOR via the aspx file . is it possible to show the values from within the split/design mode? remember that i've talking about ASP.NET and not simply C# winforms . i write this because this question was on :


and the answer that i got was for C# and winforms . i've tried to do the same for ASP.NET , but i've failed.

can anyone please help me?

SharePoint 2007 Expiration Policy Not working : Access denied for the site


I have a SharePoint 2007 List with Expiration Enabled in Information and Policy Management. I have a datatime column ExpiryDate which i used in Expiration. On Expiration I have chose to delete the item. Through Central Admin I run the expiration by clicking "Process Expired Items now" button. I got the following error in the Windows event viewer.

Expiration Service for site http://md-rmanimaran failed.

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

EventID: 5016

Category: Information Policy Management 

Where I need to specify the login details to get rid of this error? Anybody Please help..




cache condition always return flase


Hi i got a function that first insert cache object in dataset and then check if its empty then query the database otherwise just get record from the dataset of cache object.

Now the problem is, the condition

If DSEktronID Is Nothing Then '

always return false even when i run the application first time? Any ideas?

   Public Function GetEktronID(ByVal UrlAlias As String, ByVal source As Object) As Integer

Dim application As HttpApplication = DirectCast(source, HttpApplication)
Dim context As HttpContext = application.Context
Dim DSEktronID As New DataSet()
Dim da As SqlDataAdapter
Dim dt As DataTable
Dim EktronId As Integer

DSEktronID = CType(context.Cache("firmEktron"), DataSet)

If DSEktronID Is Nothing Then ' If empty
context.Response.Write("inside if")
Dim conn As SqlConnection
conn = New SqlConnection(ConfigurationManager.ConnectionStrings("GAConnectionStringDev").ConnectionString)

da = New SqlDataAdapter("select content_id, Alias FROM [tbl_MobileTodayLookUP]", conn)

DSEktronID = New DataSet()
da.Fill(DSEktronID, "Ekt
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend