如何使用sqldatasource快取機制

1.修改web.config
<system.web>
<caching>
<sqlCacheDependency enabled="true">
<databases>
<add name="twlifeacademy" connectionStringName="TWLifeAcademyConnectionString" pollTime="12000"></add>
</databases>
</sqlCacheDependency>
</caching>
</system.web>

2.設定sqldatasource啟用快取
EnableCaching="true"
SqlCacheDependency="twlifeacademy:country;twlifeacademy:student"

3.相關表格加入變更通知trigger
aspnet_regsql -S 172.16.1.111 -U sa -d twlifeacademy -et -t country