Sqlcachedependency not invalidating cache
You can set a dependency on a table in Microsoft SQL Server 7.0, SQL Server 2000, and SQL Server 2005.If you are using SQL Server 2005 you can also set a dependency on a specific record.
Using a object with SQL Server 2005 query notification does not require any explicit configuration.
This can make sure that you users always get the latest data from the server. Start() method must be called before the first SQL query is executed.
needs to be registered in your application’s configuration. This method could be placed in Application_Start() event in file.
When there is changes on the table, the trigger will be fired up and write the changes to the cache table.
After you have defined the SQL dependency, any changes that made to the database will be reflected on your web pages immediately though you have set the cache duration on the page.