Exercise 3: Create an External List to Consume the MarketPlace Dataset

Task 1 – Creating an External List

In this task, you will use Internet Explorer to navigate to Windows Azure Marketplace and register for a Marketplace account.

1. Using Internet Explorer, navigate to https://intranet.contoso.com.
2. Click on Site Actions in the upper left corner.

3. Select More Options menu item.

   Figure 45

   More Options Link

4. Select List and Data items in the left hand pane.

   Figure 46

   Create Dialog Box

5. Select External List item and click the Create button on the right hand side of the dialog.
6. Enter a name of DataGov in the name textbox.

7. Click the Select External Content Type icon in the Data source configuration section.

   Figure 47

   External Content Type

8. Select BDCModel1 and click OK.

   Figure 48

   BDCModel1 External Content Type

9. Click Create to create the external list.

10. Review the new external list.

Exercise 3 Verification

In order to verify that you have correctly performed all steps of exercise 1, proceed as follows:

Verification 1

In this verification, you will view the list and select a single list item to view.

1. Using Internet Explorer, navigate to https://intranet.contoso.com/Lists/DataGov/ReadList.aspx.
2. Verify the list loads without error.
3. Click on a City value. The item dialog box should appear displaying all the data for the item.