This walkthrough builds an ASP.NET
sample expense application using SQL Azure
for the database. Included is a sample ASP.NET solution to be used with Microsoft Visual Web Developer 2010 Express and a SQL Script to create and populate a SQL Azure database. You may follow the video and create the project yourself in Visual Studio
Express or you may use the supplied solution file which already contains the working application.
Note: Before you may begin, please run the SQLAzureExpenseDBGen.sql script to create and populate the sample database we will use in SQL Azure for the web application created in the video. It is probably easiest to do this from SQL Server Management Studio. Further, if you choose to use the provided Visual Studio Project to follow along, also note that you will need to modify the Web.config to point to your SQL Azure DB: ie – Data Source, Initial Catalog, User ID, and Password. Each item needing to be modified is marked with “xxxChangeMexxx”.