Last post Mar 30, 2012 04:53 PM by dlanz
Mar 29, 2012 03:02 PM|dlanz|LINK
Is there a better way to do this? I'm sure there are tutorials on each piece: I did a Google search and there isn't much on SQL Server to Google Maps that i found useful. I think I'll start with the SQL Server web service wrapper. Any suggestions/discussion
and tuts would be helpful.
Mar 29, 2012 03:27 PM|atconway|LINK
I did this with Silverlight and Bing maps using SQL Server lat/long data. It worked using the API exposed in the Microsoft.Maps.MapControl.dll to manipulate the pins on the map. The nice thing about using the Bing maps is the MSFT support and documentation
for .NET was superb.
You need to just see how the Google maps API is exposed to .NET and once you pull back the data from SQL (in any several different ways available: raw ADO.NET, EF, etc.), apply that to the map. I don;t think you will have to have a service in between unless
you want or need it in between for being used my multiple applications (meaning centralized calls to SQL to get the data and expose the lat/long info).
Mar 30, 2012 04:53 PM|dlanz|LINK
I have my webservice up and running; I'm going to try to JSONize it if I can. This should allow me to use jQuery to invoke the service and parse the response (I hope)