2006-11-22
Asp.Net2.0 SqlCache的使用步驟
1.使用aspnet_regsql開啟資料庫cache功能
aspnet_regsql.exe -S -E -d -et -t <表格>
2.寫入web.config
3.設定datasource
或<%@ OutputCache Duration="999999" SqlDependency="Northwind:Employees" VaryByParam="none" %>
EnableCaching="True" SqlCacheDependency="Northwind:Employees" cacheduration="infinite"
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/caching/SQLInvalidation.aspx
aspnet_regsql.exe -S
2.寫入web.config
3.設定datasource
或<%@ OutputCache Duration="999999" SqlDependency="Northwind:Employees" VaryByParam="none" %>
EnableCaching="True" SqlCacheDependency="Northwind:Employees" cacheduration="infinite"
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/caching/SQLInvalidation.aspx