public static void Main()
{
// <Snippet1>
// Get the Web application configuration.
System.Configuration.Configuration webConfig =
WebConfigurationManager.OpenWebConfiguration("/aspnetTest");
// Get the section.
string configPath = "system.web/cache/sqlCacheDependency";
System.Web.Configuration.SqlCacheDependencySection sqlDs =
(System.Web.Configuration.SqlCacheDependencySection)webConfig.GetSection(
configPath);
// </Snippet1>
// <Snippet2>
// Get the current Databases collection.
SqlCacheDependencyDatabaseCollection databasesValue =
sqlDs.Databases;
// </Snippet2>
// <Snippet3>
// Get the current PollTime property value.
Int32 pollTimeValue = sqlDs.PollTime;
// Set the PollTime property to 500 milliseconds.
sqlDs.PollTime = 500;
// </Snippet3>
// <Snippet4>
// Get the current Enabled property value.
Boolean enabledValue = sqlDs.Enabled;
// Set the Enabled property to false.
sqlDs.Enabled = false;
// </Snippet4>
}
public static void Main(string[] args)
{
// <Snippet1>
// Get the Web application configuration.
Configuration webConfig =
WebConfigurationManager.OpenWebConfiguration("/aspnetTest");
// Get the section.
string configPath = "system.web/cache/sqlCacheDependency";
SqlCacheDependencySection sqlCacheDependencySection =
(SqlCacheDependencySection)webConfig.GetSection(configPath);
// Get the database element at the specified index.
SqlCacheDependencyDatabaseCollection sqlCdds =
sqlCacheDependencySection.Databases;
// </Snippet1>
// <Snippet2>
object[] collectionKeys = sqlCdds.AllKeys;
// </Snippet2>
// <Snippet3>
SqlCacheDependencyDatabase dbElement =
new SqlCacheDependencyDatabase(
"dataBase", "dataBaseElement", 500);
sqlCdds.Add(dbElement);
// </Snippet3>
// <Snippet4>
sqlCdds.Clear();
// </Snippet4>
// <Snippet5>
SqlCacheDependencyDatabase dbElement1 =
sqlCdds.Get(0);
// </Snippet5>
// <Snippet6>
SqlCacheDependencyDatabase dbElement3 =
sqlCdds.Get("dataBaseElement");
// </Snippet6>
// <Snippet7>
string thisKey = sqlCdds.GetKey(0).ToString();
// </Snippet7>
// <Snippet8>
sqlCdds.Remove("dataBaseElement");
// </Snippet8>
// <Snippet9>
sqlCdds.RemoveAt(0);
// </Snippet9>
// <Snippet10>
SqlCacheDependencyDatabase dbElement2 =
new SqlCacheDependencyDatabase(
"dataBase2", "dataBaseElement2", 500);
sqlCdds.Set(dbElement2);
// </Snippet10>
}
