Northwind Office Business Application

This sample demonstrates a simple Office Business Application used by the new Northwind Traders built with Visual Studio 2008 Service Pack 1. It follows the workflow of accepting purchase orders through email all the way to shipping. It shows how to expose LOB data using ADO.NET Data Services as well as interact with it in Outlook, Word, Excel and SharePoint 2007.

Please read the companion article series for step-by-step information on building this sample:

Building an Office Business Application
OBA Part 1 - Exposing Line-of-Business Data
OBA Part 2 - Building an Outlook Client against LOB Data
OBA Part 3 - Storing and Reading Data in Word Documents
OBA Part 4 - Building an Excel Client against LOB Data
OBA Part 5 - Building the SharePoint 2007 Workflow

This sample was built using Visual Studio 2008 Professional Service Pack 1 and it demonstrates:

1. A way to easily expose LOB data using ADO.NET Data Services
2. An Outlook Add-in that displays LOB data in a WPF control
3. How to store and retrieve structured data from Word 2007 documents
4. An Excel document customization that edits LOB data provides data visualization
5. A SharePoint 2007 Document Library Workflow that adds Order info to the database by reading word documents and updates and reports order statuses based on changes in the database using ADO.NET Data Services

Download the latest release here

PLEASE READ THIS
This sample uses the Northwind sample database you can download here. The sample contains a database project that includes change scripts to add EmailAddress to customers and employees tables as well as OrderNumber to the Orders table so please make sure you run those before attempting to run the sample. You may also need to update the connection string located in the Web.config of the NorthwindDataService project.

You will also need to download the Open XML SDK.