DCSIMG

 Subscribe in a reader
Screen cast: Notifications in SQL 2005 using SqlDependency - Guy kolbis
Saturday, August 18, 2007 3:37 PM kolbis

Screen cast: Notifications in SQL 2005 using SqlDependency

One of the classic problems with database applications is refreshing stale data.

In a nutshell, Query Notification allows you to cache data and be notified when the data has been changed in SQL Server. Upon notification, you can then refresh your cache or take whatever action you need to.

In the following screen cast I will examine the capabilities of the notification services using the SqlDependency class.

 

 

You can download the sample code from here.

You can download the screen cast from here.

תגים:, , ,

תוכן התגובה

# re: Screen cast: Notifications in SQL 2005 using SqlDependency

kolbis כתב/ה

When you use the notification services in Sql 2005, and you are using the default implementation (SqlNotification), you will be notified that something has changed in the database and you may want to reload the data. However, you won't know what exactly what has changed and you won't be able to reload only those changes. So, if you don’t mind loading everything all over again with each change, you can use notification, but if you want to be more accurate and reload only the Delta, you must consider other kind of mechanism for notification. Because "read only" or "read most" rarely changes, you will not mind using the default implementation of the Sql notification services.

Saturday, September 01, 2007 11:30 PM

שלח תגובה

(שדה חובה) 
(שדה חובה) 
(אופציונלי)
(שדה חובה) 

Enter the numbers above: