SQL Server 2005实现数据库缓存依赖

SelectDATABASEpRoPERTYEX('数据库名称','IsBrokerEnabled')

SqlDependency.Start(connectionString);//推荐将这段代码加到Global.asax的application_Start *** 中
SqlDependency.Stop(connectionString);//用于关闭，可加在Global.asax的Application_End *** 中

SqlConnectionconn=newSqlConnection(strConnection);
SqlCommandcommand=newSqlCommand(strCommandText,conn);
SqlCacheDependencydependency=newSqlCacheDependency(command);
//注册 *** 到委托，该委托是
CacheItemRemovedCallbackonRemove=newCacheItemRemovedCallback(RemovedCallback);
//新增或修改一条缓存记录
Cache.Insert(strCacheKey,objAppCache,dependency,abSOLuteExpiration,
slidingExpiration,CacheItemPriority.Default,onRemove);

SqlConnectionconn=newSqlConnection(strConnection);
SqlCommandcommand=newSqlCommand(strCommandText,conn);
SqlCacheDependencydependency=newSqlCacheDependency(command);
dependency.OnChange+=newOnChangeEventHandler(Dependency_OnChange);