This walkthrough demonstrates how to use the Windows Azure AppFabric Cache to cache data from a SQL Azure database. This includes:

• Populating an ASP.NET GridView control from SQL Azure
• Provisioning a Windows Azure AppFabric Cache
• Retrieving SQL Azure data into the default cache
• Retrieving SQL Azure data from the default cache
• Enabling the local cache
• Retrieving SQL Azure data from the local cache
• Using ASP.NET code to compare the performance benefits

If you want to follow along with the video, this archive has the following resources:

• Microsoft Access database containing the sample data. See Migrating from Access to SQL Azure on CodePlex for help on deploying the data to SQL Azure.
• Solution file containing sample code of the beginning state of the project
• Text file containing cut-and-paste code samples to achieve the end state of the project
• This readme file

Prerequisites to Run the Solution

• SQL Azure account (see Creating an Account and Your SQL Azure Database on CodePlex)
• SQL Azure database provisioned with data migrated from the Access database
• Connection string for the SQL Azure database in web.config
• AppFabric Portal account (described in the video) to provision the cache
• Visual Studio 2010 or Visual Web Developer Express

Click here to view video on Showcase