Gets or sets a user-defined key dependency that is linked to all data cache objects that are created by the data source control. All cache objects are explicitly expired when the key is expired.
Syntax
public virtual string CacheKeyDependency { set; get; }
Value
Documentation for this section has not yet been entered.
Remarks
The System.Web.UI.WebControls.SqlDataSource control supports data caching. While data is cached, the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method retrieves data from the cache rather than from the underlying database. When the cache expires, the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method retrieves data from the underlying database, and then caches the data again.
You can set the SqlDataSource.CacheKeyDependency property to create a dependency between all cache entries that are created by the System.Web.UI.WebControls.SqlDataSource control and the key. You can programmatically expire all the cache entries at any time by expiring the key.
The System.Web.UI.WebControls.SqlDataSource control can cache data only when in the SqlDataSourceMode.DataSet mode. A NotSupportedException exception is thrown by the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method, if the System.Web.UI.WebControls.SqlDataSource control is set to the SqlDataSourceMode.DataReader value and caching is also enabled.
A unique cache entry is created for every combination of the SqlDataSource.SelectCommand, SqlDataSource.ConnectionString, and SqlDataSource.SelectParameters properties. Multiple System.Web.UI.WebControls.SqlDataSource controls can use the same cache entries in scenarios where the controls load the same data from the same underlying database.
When you are using client impersonation under Microsoft Windows authentication, the data is cached when the first user accesses the data. If another user requests the same data, the data is retrieved from the cache. The data is not retrieved by making another call to the database to verify the user's access to the data. If you expect more than one user to access the data, and you want each retrieval to the data to be verified by the security configurations for the database, do not use caching.
Requirements
Assembly: System.Web (in System.Web.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0