Data Connector is an Open Source + Open Data project focused on connecting the power of Bing Maps Silverlight Control to the spatial query capabilities of SQL Server 2008.

The current project consists of two separate components - SQL Server Database + DataConnector Source Code:

1. DataConnector.zip - DataConnectorWCF Services for connecting to SQL Server and returning query results plus example DataConnectorUI2 in a VS2008 solution
2. SampleGeographyDataR2.zip or SampleGeographyDataR1.zip - SQL Server 2008 R2 spatial database .bak is not compatible with R1

Live Example of DataConnector

Installing:

After unzipping DataConnector.zip project and opening in Visual Studio 2008

Step 1 - Update the DataConnectorWCF Web.config file with a connection string suitable to your local system:

<connectionStrings>
<add name="DataConnectionString" connectionString="Data Source=Add Your SQL Server Here;Initial Catalog=SampleGeographyData
;User Id=Add your user name here;Password=Add your Password here;Pooling=true;Min Pool Size=5;Max Pool Size=100;Connect Timeout=15;"/>
</connectionStrings>

Step 2 - Update the DataConnectorUI2.Web Web.config file:

1. Replace with your Bing Key:<add key="BingKey" value="Your Bing Key Here"/>
2. Change tile service url to point to your DataConnector deployment <add key="TileService" value="http://Your Url Here/Services/Tile.svc/"/>

Step 3 - After unzipping SampleGeographyDataR2.zip or SampleGeographyDataR1.zip into a subdirectory on your local system, use Microsoft SQL Server Management Studio to restore the SampleGeographyData.bak as a Database in your local SQL Server 2008. Note: If you are using SQL Server 2008 R1 you will need to download and use the R1 .bak version.


License Apache v2.0