I have a database running on MS SQL Server 2005 and an ASP.NET 3.5 web application. The database contains a product catalog which I'm using to feed "pages" into a CMS running in the web app. Once the pages have been created the application caches them so I need to notify the application of this change so it can recreate the page objects...
Does SqlDependency (for example) fires the OnChange event, when the invocation of previous event handler didn't finish? (Assume that OnDependencyChange method is very time consuming) What exactly happens? SqlDependency dependency=new SqlDependency(command); // Subscribe to the SqlDependency event. dependency.OnChange += new OnChangeEv...
I started looking at this recently with the very limited knowledge that the ASP.NET Cache could somehow make use of a SqlCacheDependency to invalidate the cache when a table (or a queries results) change. This lead me to the SQLDependency and SqlNotificationRequest classes. While the details of the SqlNotificationRequest class still e...
I'm having a really tough time finding authoritative information on how to set up and use SqlDependency caching with SQL Server 2008. We've implemented the use of sql dependency cache, and it's working in our dev environment. Unfortunately, with the default settings the user needs to have quite elevated permissions which our DBAs will no...
Environment: Replicated Server: SQL Server 2008 R2 Client Server: SQL Server Express Language: .Net 3.5 C# The replicated server will be continually updated by web services and have many of the tables published. The Client Server will have a down stream subscription to the replicated server. Goal: As the SQL Express instance pulls it...
I am trying to get query notifications to work, but my application is not receiving any notifications. How do I debug Query Notifications? I am using the code availble here http://www.codeproject.com/KB/database/chatter.aspx. I can see that the queues, the services and the stored procedures are being created on the server, but the OnCha...