asp.net2.0 緩衝：資料庫依賴

Web.config

<configuration>

 <appSettings/>

 <connectionStrings>
  <add name="TestConnectionString" connectionString="server=shgpc150\sql2k;database=Northwind;uid=sa;pwd=;"></add>
 </connectionStrings>

 <system.web>
  <caching>
   <sqlCacheDependency enabled="true" pollTime="1000">
    <databases>
     <add name="Northwind" connectionStringName="TestConnectionString" pollTime="1000"></add>
    </databases>
   </sqlCacheDependency>
  </caching>
............

Page_Load.

System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications(System.Configuration.ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString);
        System.Web.Caching.SqlCacheDependencyAdmin.EnableTableForNotifications(System.Configuration.ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString, "Employees");

        if (HttpContext.Current.Cache["dsEmpployees"] == null)
        {
            System.Web.Caching.SqlCacheDependency depe = new System.Web.Caching.SqlCacheDependency("Northwind", "Employees");
            HttpContext.Current.Cache.Insert("dsEmpployees", "dsEmpployees", depe);
            Label1.Text = "new cache generated!";
        }
        else
        {
            Label1.Text = "Load data from cache";
        }