Code Sample: Federated Search SQL Server Connector

Applies to: SharePoint Server 2010

In this article
Prerequisites
Setting Up the AdventureWorksDW Database
Completing the Walkthrough

By using the Federated Search SQL Server Connector sample, you can learn how to create a connector that can return federated search results from a Microsoft SQL Server database.

This sample shows how to do the following:

1. Implement a basic federated search connector.

2. Query an instance of a database that is running on the local server and return the results to SharePoint Enterprise Search in RSS format.

3. Provide search results HTML for a More Results link.

4. Create a location for the federated search connector by using the Search Administration site.

5. Test the sample by configuring an instance of the Federated Search Results Web Part to use the location for the federated search connector.

The complete code for this sample is available in the Federated Search SQL Server Connector Sample resource page.

Prerequisites

To use the Federated Search Connector sample, you must have the following installed in your development environment:

• Microsoft SharePoint Server 2010

• Microsoft SQL Server 2008 on the same server with SharePoint Server 2010.

• Microsoft Visual Studio 2010 with Microsoft Visual C# or Microsoft Visual Basic enabled

Setting Up the AdventureWorksDW Database

Obtain the AdventureWorksDW database and install it on the server running SQL Server, as follows:

1. Go to SQL Server 2008 SR4.

2. Download AdventureWorks2008_SR4.exe.

Completing the Walkthrough

The following topics walk you through how to create a federated search SQL Server connector and deploy it:

• Step 1: Create the Project for the Federated Search SQL Server Connector

• Step 2: Deploy and Test the Federated Search SQL Server Connector

See Also

Concepts

Architecture Guidance for Building Federated Search Connectors

Federated Search Overview