Professional in C# and Visual Basic Part 114. Building on the revolutionary release, adds several key new developer features including AJAX, LINQ, and a new CSS designer in Visual Web Developer 2008. The dramatic reduction in code that developers realized from the more than 50 new server controls in now allows developers the time to make their applications more interactive with AJAX, to work with data in their preferred language with LINQ, and to build visually attractive and consistent standards-based sites with CSS. . | Chapter 23 Caching Go ahead and enable both the Customers and Product tables. You run the command once per table. After a table is successfully enabled you receive the following response Enabling the table for SQL cache dependency. . Finished. After the table is enabled you can begin using the SQL cache invalidation features. However before you do the following section shows you what happens to SQL Server when you enable these features. Looking at SQL Server 2000 Now that the Northwind database and the Customers and Products tables have all been enabled for SQL cache invalidation look at what has happened in SQL Server. If you open up the SQL Server Enterprise Manager you see a new table contained within the Northwind database AspNet_SqlCacheTablesFor-ChangeNotification whew that s a long one . Your screen should look like Figure 23-4. Note that SQL Server 2000 isn t supported on Vista so this is a screenshot of a remote SQL 2000 machine viewed from the SQL Management Studio running on Vista. Figure 23-4 At the top of the list of tables in the right-hand pane you see the AspNet_SqlCacheTablesForChange-Notification table. This is the table that uses to learn which tables are being monitored for 1089 Chapter 23 Caching change notification and also to make note of any changes to the tables being monitored. The table is actually quite simple when you look at the details as illustrated in Figure 23-5. Table - Summary tableName notificationCreated changeid Customers 9 19 2007 1 38 47 PM 0 Products 9 19 2007 1 38 43 PM 0 NULL NULL NULL Figure 23-5 In this figure you can see three columns in this new table. The first is the tableName column. This column simply shows a String reference to the names of the tables contained in the same database. Any table named here is enabled for SQL cache invalidation. The second column notificationCreated shows the date and time when the table was enabled for SQL cache invalidation. The final column changeid
