Exercise 1: Creating a SharePoint List Data Source

In this exercise, you will deploy a list template to SharePoint and make a list based upon the template. The list template defines a list used to hold maintenance requests. In this scenario, the Windows Phone 7 application will read the maintenance requests from the SharePoint list and query a SQL Azure database to determine if the appropriate replacement parts associated with each maintenance request are in stock. The Windows Phone 7 application will present this information to help maintenance personnel complete maintenance requests.

In this exercise, you will enable OData access to the SQL Azure database.

Task 1 – Deploying the List Template to a SharePoint Site

In this task, you will deploy the maintenance requests list template to a SharePoint site. The list template contains sample data used in the lab.

1. Open Internet Explorer and navigate to the SharePoint Team Site configured for Forms Based Authentication.

example: https://fbawp7

1. Log into the site using site collection administrator credentials.
2. Click Site Actions, and select Site Settings.
3. In the Galleries section, click List templates.
4. In the Ribbon, click the Documents tab.
5. Click Upload Document.
6. Click Browse…
7. Browse to the Maintenance Requests.stp file located at %TrainingKitPath%\Labs\IntegratingAzureCloudData\Source\Before and select it.
8. Click Open.
9. Click OK.

10. Click Save. Verify the Maintenance Requests list template appears in the List Templates Gallery.

    Figure 2

    Maintenance Requests list template

Task 2 – Creating the Maintenance Requests List

In this task, you will use the maintenance requests list template to create the maintenance requests list.

1. Open Internet Explorer and navigate to the SharePoint Team Site configured for Forms Based Authentication.

   example: https://wp7fba

2. Log into the site using site collection administrator credentials.
3. Click Site Actions and select More Options.
4. In the Filter By section, select List.

5. Select the Maintenance Requests list.

   Figure 3

   Create list dialog

6. In the Name textbox enter Maintenance Requests.
7. Click Create.

8. Verify the Maintenance Requests list contains the following sample data.

   Figure 4

   The new Maintenance Requests list with sample data