Code Sample: AdventureWorks2008 Declarative Outlook Solution

Applies to: SharePoint Server 2010

The AdventureWorks2008 Declarative Outlook Solution sample enables you to track contacts from a database external system by accessing them in Microsoft Outlook as native Outlook contacts. This sample enables you to create, edit, and delete customers in the back-end external system. The external system is the AdventureWorks 2008 sample database, which is a sample database provided by Microsoft for free.

This sample provides a task pane visible in the Outlook Contact view that shows a list of all orders placed by a customer in the database. The task pane also displays the details of a customer order when the order is selected from the list.

Finally, a URL-based action is provided. This action searches the MSN White Pages to look up the contact's telephone number as a parameter and to provide contextual information.

Prerequisites:

  • Internet Information Services (IIS)

  • Microsoft .NET Framework 3.5 Service Pack 1

  • Microsoft SharePoint Server 2010

  • Microsoft SQL Server 2008 (and SQL Management Studio)

  • Microsoft Office Professional Plus 2010

Download and use the sample

  1. Download the Microsoft SharePoint 2010 Software Development Kit (SDK) from SharePoint 2010 Reference: Software Development Kit.

  2. Extract bcs sample kit.zip from the path %ProgramFiles%\Microsoft SDKs\SharePoint 2010\Samples\Business Connectivity Services to a local folder.

  3. In the folder where you extracted the files, locate the AdventureWorks2008 Declarative Outlook Solution Sample folder and open the Readme.htm file.

  4. Follow the instructions in Readme.htm to use the sample.