DataConnector

Rating: No reviews yet
Downloads: 6564
Released: Jun 25, 2010
Updated: Jun 28, 2010 by rkgeorge
Dev status: Beta Help Icon

Recommended Download

Application DataConnector.zip
application, 7190K, uploaded Jun 26, 2010 - 4534 downloads

Other Available Downloads

Example SampleGeographyDataR1.zip
example, 80668K, uploaded Jun 26, 2010 - 1000 downloads
Example SampleGeographyDataR2.zip
example, 66386K, uploaded Jun 26, 2010 - 1030 downloads

Release Notes

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

Reviews for this release

No reviews yet for this release.