Outlook Contacts Sync SQL Server – Iteration 1 User Stories

  1. As an Outlook user, I want to synchronize contact fields to a SQL Server database.
  2. As an Outlook user, I am occasionally disconnected from the network / Internet. Therefore, I need my contacts available while offline.
  3. As a user, all of my existing contacts must be preserved while and after running the sample.

Outlook Contacts Sync SQL Server – Iteration 1 Prerequisites

  • Visual Studio 2010 SP1
  • Outlook 2012

How to install AdventureWorksLT2012_SyncSample database

The AdventureWorksLT2012_SyncSample database can be installed using the CREATE DATABASE statement or by attaching the database.

To install AdventureWorksLT2012_SyncSample database

  1. Download OutlookSyncSQL.zip .

  2. From the License Agreement, click I Agree.

  3. From File Download, click Save and browse to a location on your desktop.

  4. Unzip OutlookSyncSQL.zip and copy \Database\AdventureWorksLT2012_SyncSample_Data.mdf to a folder.

  5. From SQL Server Management Studio, execute the following code:

    CREATE DATABASE AdventureWorks2012 ON (FILENAME = '{drive}:\{file path}\AdventureWorksLT2012_SyncSample_Data.mdf’) FOR ATTACH_REBUILD_LOG;

    As an alternative to step 4, you can attach the database using the SQL Server Management Studio user interface. For more detailed information, see Attach a Database (SQL Server Management Studio) .


    You must remove the log file from the list of files to attach. This will cause the operation to rebuild the log.

How to compile Iteration 1

Outlook Contacts Sync SQL Server – Iteration 1 includes a set of unit tests. The unit tests demonstrate

  • How to use relevant Outlook properties and methods with SQL Server.
  • How to perform CRUD operations against a modified version of AdventureWorksLT2012.

To run the unit tests, you will need to compile the OutlookSyncSQLAddin project before the MyDataTestProject (unit test) project.

See Example Unit Test.

How to run Iteration 1

To run iteration 1, open OutlookSyncSQL.sln in Visual Studio 2010 and run the sample.

Note The sample source project will install the OutlookSyncSQLAddin Outlook 2010 add-in.


Example Unit Tests

Last edited May 11, 2012 at 12:26 AM by DerrickVMSFT, version 5


No comments yet.