Mihail Mateev : GIS, VS2010, WCF

Using Infragistics Map control extensions with SQL Server 2008 via WCF

[Infragistics] Mihail Mateev — Tue, 23 Aug 2011 12:42:00 GMT

Often you may want to use the Map components Infragistics LightSwitch for a spatial data type, different from shapefiles.

In this case the NetAdvantage for Visual Studio LightSwitch offers convenient option of using WCF as a source of spatial data.
Thus you can use different data, such as implementation-reading of the data depends solely on you. This article will be shown examples of spatial data from SQL Server 2008.

Will be shown examples of different implementation of WCF - as a WCF Service Application, WCF Service in the ASP.Net Application, Silverlight-enabled WCF Service.
The reason I talk about different types of WCF is in need of different options for implementation. Client part of the program is clean LightSwitch Silverlight, which has some features using WCF. Referencing the data is hidden in the Map control extensions. The only thing you need to make user Visual Studio LightSwitch is set to the appropriate endpoint Uri WCF service.

Requirements for implementation of WCF for Infragistics Map control extensions.

Each as far as WCF service must have:
public class SqlDbService or public interface ISqlDbService with ServiceContract attribute. When we have in Interface ISqlDbService SqlDbService class should inherit ISqlDbService.
You should have in this class a method, named GetSpatialData. Declaration of the method should have OperationContract attribute.

The implementation below is used in all cases except Silverlight-enabled WCF Service

Interface ISqlDbService:

[ServiceContract(Namespace = "")]

 public interface ISqlDbService

 {

     [OperationContract]

     IEnumerable<Dictionary<string, string>> GetSpatialData();

 }

SqlDbService class:

  

    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

    public class SqlDbService : ISqlDbService

    {

  

  

        #region GetSpatialData

  

        public IEnumerable<Dictionary<string, string>> GetSpatialData()

        {

  

            return GetCountries();

        }

        #endregion //GetSpatialData

  

        private IEnumerable<Dictionary<string, string>> GetCountries()

        {

            string connectionString =

            System.Configuration.ConfigurationManager.AppSettings["connectionString"];

            List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

  

            SqlConnection sqlConnection = new SqlConnection();

            sqlConnection.ConnectionString = connectionString;

            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.Connection = sqlConnection;

            sqlCommand.CommandText = "SELECT geom, CNTRY_NAME, POP_CNTRY FROM world";

            //sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;

            //sqlCommand.CommandText = "get_WorldData";

  

            sqlConnection.Open();

            SqlDataReader reader = sqlCommand.ExecuteReader();

  

            if (reader != null)

                while (reader.Read())

                {

                    Dictionary<string, string> valueDictionary = new Dictionary<string, string>();

  

                    for (int i = 0; i < reader.FieldCount; i++)

                    {

                        valueDictionary.Add(reader.GetName(i), reader.GetValue(i).ToString());

                    }

  

                    list.Add(valueDictionary);

                }

  

            sqlConnection.Close();

            sqlConnection.Dispose();

  

            return list;

        }

  

    }

Implementation for Silverlight-enabled WCF Service :

[ServiceContract(Namespace = "")]

[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

public class SqlDbService

{

  

    #region GetSpatialData

    [OperationContract]

    public IEnumerable<Dictionary<string, string>> GetSpatialData()

    {

        string connectionString =

                System.Configuration.ConfigurationManager.AppSettings["connectionString"];

        List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

  

        SqlConnection sqlConnection = new SqlConnection();

        sqlConnection.ConnectionString = connectionString;

        SqlCommand sqlCommand = new SqlCommand();

        sqlCommand.Connection = sqlConnection;

        sqlCommand.CommandText = "SELECT geom, CNTRY_NAME, POP_CNTRY FROM world";

  

        sqlConnection.Open();

        SqlDataReader reader = sqlCommand.ExecuteReader();

  

        if (reader != null)

            while (reader.Read())

            {

                Dictionary<string, string> valueDictionary = new Dictionary<string, string>();

  

                for (int i = 0; i < reader.FieldCount; i++)

                {

                    valueDictionary.Add(reader.GetName(i), reader.GetValue(i).ToString());

                }

  

                list.Add(valueDictionary);

            }

  

        sqlConnection.Close();

        sqlConnection.Dispose();

  

        return list;

    }

    #endregion //GetSpatialData

}

In all cases you should have class with the exact name SqlDbService and method with name GetSpatialData.

Declaration of the class / interface should have ServiceContract attribute. Declaration of the method should have OperationContract attribute (general requirements for WCF).

It is also possible to use any kind of data in your method implementation. Just the return data should be a nested collection from type:

   1: IEnumerable<Dictionary<string, string>>

Next snippet shows implementation of the GetSpatialData method, using stored procedure:

Stored procedure code:

USE [SqlSpatialDemo]

GO

  

/****** Object:  StoredProcedure [dbo].[get_WorldData]    Script Date: 08/23/2011 10:46:56 ******/

SET ANSI_NULLS ON

GO

  

SET QUOTED_IDENTIFIER ON

GO

  

-- =============================================

-- Author:        <Author,,MIHAIL MATEEV>

-- Create date: <Create Date,,3/8/2010>

-- Description:    <Description,,GetWorldLayer>

-- =============================================

CREATE PROCEDURE [dbo].[get_WorldData]

    -- Add the parameters for the stored procedure here

    --<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 

    --<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>

AS

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

  

    -- Insert statements for procedure here

    SELECT geom, CNTRY_NAME, POP_CNTRY FROM world

END

  

GO

GetSpatialData implementation:

[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

public class SqlDbService : ISqlDbService

{

  

  

    #region GetSpatialData

  

    public IEnumerable<Dictionary<string, string>> GetSpatialData()

    {

  

        return GetCountries();

    }

    #endregion //GetSpatialData

  

    private IEnumerable<Dictionary<string, string>> GetCountries()

    {

        string connectionString =

        System.Configuration.ConfigurationManager.AppSettings["connectionString"];

        List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

  

        SqlConnection sqlConnection = new SqlConnection();

        sqlConnection.ConnectionString = connectionString;

        SqlCommand sqlCommand = new SqlCommand();

        sqlCommand.Connection = sqlConnection;

        sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;

        sqlCommand.CommandText = "get_WorldData";

  

        sqlConnection.Open();

        SqlDataReader reader = sqlCommand.ExecuteReader();

  

        if (reader != null)

            while (reader.Read())

            {

                Dictionary<string, string> valueDictionary = new Dictionary<string, string>();

  

                for (int i = 0; i < reader.FieldCount; i++)

                {

                    valueDictionary.Add(reader.GetName(i), reader.GetValue(i).ToString());

                }

  

                list.Add(valueDictionary);

            }

  

        sqlConnection.Close();

        sqlConnection.Dispose();

  

        return list;

    }

  

}

Demo Application

Sample application is based on the application, used in t the article "Create Thematic Maps in Visual Studio LightSwitch with Infragistics Geospatial Map".

You could use any of the sample WCF implementations.

Screens below show variant with WCF Service in the ASP.Net Application.

Run the web application.

In the Visual Studio LightSwitch application –> Screens –> Customers Map –>Country (Infragistics Map Control) change the settings in accordance with the screen below:

Settings are the same for both” Infragistics Map Control and Infragistics Geospatial Map.

Run the application and select the screen, named Customers Map.

Enjoy the spatial data from SQL Server 2008!

Sample application is available here:(Please visit the site to view this media)

SqlSpatialDemo database is available here:(Please visit the site to view this media)

WCF Service in the ASP.Net Application implementation is available here:(Please visit the site to view this media)

WCF Service Application implementation is available here:(Please visit the site to view this media)

Silverlight-enabled WCF Service implementation is available here:(Please visit the site to view this media)

Using spatial data in the Windows Azure Blob Storage

[Infragistics] Mihail Mateev — Sun, 17 Apr 2011 10:00:00 GMT

When talking about spatial data in the Windows Azure understand SQL Azure Spatial. Windows Azure presents other options when you file your sources for spatial data is to use Windows Azure Blob Storage. Due to the lack of good examples of this I decided to write this article.

Demo application is a Silverlight application for visualization of spatial data that uses data from the Windows Azure Blob Storage. This application uses Infragistics Silverlight XamMap component for visualization of spatial data.

Unlike my other articles about Windows Azure that will use in Windows Azure Emulator, which is installed with Windows Azure Tools and you can use to test your Windows Azure applications.

Windows Azure Blob Storage Concepts

Accessing the Windows Azure Storage is done via a storage account. A storage account can have many blob containers.
A container is a user-defined set of blobs that has only properties, which include a list of the blobs it contains. Containers don’t store data directly.

Defining the blob

The word blob stands for binary large objects. Blobs store binary data, such as images, XML documents, compressed (zipped or gzipped) files, and other content as an arbitrary array of bytes within a container that’s associated with a storage account.

Blob URL

http://<Account>.blob.core.windows.net/<Container>/<BlobName>

Example:

Account – sally
Container – music
BlobName – rock/rush/xanadu.mp3
URL: http://sally.blob.core.windows.net/music/rock/rush/xanadu.mp3

Types of Blobs

Block Blob

A Block blobs is a collection of blocks, where each block has a block ID (of 64 bytes). A Block Blob can be up to 200GB. You can upload a maximum of 64MB of data in a Put Blob operation to create a blob. If it is larger than 64MB it must be sent in multiple chunks of no more than 4MB, with Put Block operations.

Page Blob

A Page Blob can be up to 1TB is size and is organized into 512 byte pages within the block. Any point in the blob can be accessed for read or write operations by using the offside from the start of the blob.

Requirements to build a sample application:

Visual Studio 2010
SQL Server 2008 R2 Express or higher license. (to use a Windows Azure emulator)
NetAdvantage for Silverlight Data Visualization 2010 vol.3
The most recent version of Windows Azure Tools for Visual Studio
Windows Azure account

Steps to create the sample application

Create a Silverlight Application, hosted in an ASP.Net Web Application.
Add references to Microsoft.WindowsAzure.Diagnostics, Microsoft.WindowsAzure.ServiceRuntime and Microsoft.WindowsAzure.StorageClient from Windows Azure SDK.
Implement a WCF to upload and download files, using Windows Azure Blob Storage.
Add in the client Silverlight application XamMap component.
Implement shapefile loading from Isolated Storage to XamMap.
Create a new Windows Azure Storage Account and a Hosted Service (if you are using a Windows Azure Account).
Add a Web Role project in Solution
Edit settings in ServiceReferences.ClientConfig .
Publish the Windows Azure Cloud Service (if you are using a Windows Azure Account). :
Run the demo application

Create a Silverlight Application, hosted in an ASP.Net Web Application.

Add references to Microsoft.WindowsAzure.Diagnostics, Microsoft.WindowsAzure.ServiceRuntime and Microsoft.WindowsAzure.StorageClient from Windows Azure SDK.

Add in the client Silverlight application XamMap component.

<ig:XamMap  

            HorizontalAlignment="Stretch" 

            Margin="30" 

            x:Name="xamMap" 

            VerticalAlignment="Top" 

            ElementClick="XamMapElementClick"

            MapProjectionType="Equirectangular"

            Loaded="XamMapLoaded" >

    <ig:MapNavigationPane Name="navPane" Width="100" Height="300" Margin="0,0,0,0" 

            HorizontalAlignment="Left" VerticalAlignment="Top"/>

  

    <ig:XamMap.Layers>

            <ig:MapLayer 

            x:Name="World" Brushes="#4C2C42C0 #4C218B93 #4CDC1C1C #4C3D7835 #4C701B51" 

            FillMode="Choropleth">

                

                <ig:MapLayer.ValueScale>

                    <ig:LinearScale IsAutoRange="True"/>

                </ig:MapLayer.ValueScale>

            </ig:MapLayer>

        </ig:XamMap.Layers>

</ig:XamMap>

Implement a WCF to upload and download files, using Windows Azure Blob Storage.

Create a method UploadFile that receives file name and file content as byte array. This method saves a file in the blob storage.

#region UploadFile

/// <summary>

/// Uploads a file with specified file name

/// and content like a byte array.

/// </summary>

/// <param name="fileName">Name of the file.</param>

/// <param name="data">The data.</param>

[OperationContract]

public void UploadFile(string fileName, byte[] data)

{

  

    this.EnsureContainerExists();

  

    var newId = Guid.NewGuid();

  

    SaveShapeFile(newId.ToString(), null, fileName, @"application/octet-stream", data);

  

}

#endregion //UploadFile

#region EnsureContainerExists

 private void EnsureContainerExists()

 {

     var container = GetContainer();

     container.CreateIfNotExist();

  

     var permissions = container.GetPermissions();

     permissions.PublicAccess = BlobContainerPublicAccessType.Container;

     container.SetPermissions(permissions);

 }

 #endregion //EnsureContainerExists

SaveShapeFile writes file in the blob block isolated storage.

#region SaveShapeFile

 private void SaveShapeFile(string id, string description, string fileName, string contentType, byte[] data)

 {

     var blob = GetContainer().GetBlobReference(fileName);

  

     blob.Properties.ContentType = contentType;

     var metadata = new NameValueCollection();

     metadata["Id"] = id;

     metadata["Filename"] = fileName;

     metadata["Description"] = String.IsNullOrEmpty(description) ? "unknown" : description;

  

     blob.Metadata.Add(metadata);

     blob.UploadByteArray(data);

 }

 #endregion //SaveShapeFile

Create a method DownloadFile that receives a content as byte array for specified file name.

#region DownloadFile

/// <summary>

/// Downloads the file with specified file name.

/// </summary>

/// <param name="fileName">Name of the file.</param>

/// <returns></returns>

[OperationContract]

public byte[] DownloadFile(string fileName)

{

    try

    {

        var srcBlob = this.GetContainer().GetBlobReference(fileName);

        byte[] data = srcBlob.DownloadByteArray();

        return data;

    }

    catch (Exception)

    {

        return null;

    }

}

#endregion //DownloadFile

private void BtnUploadFile_Click(object sender, RoutedEventArgs e)

{

    //create an object for file open dialog

    _openDialog = new

    OpenFileDialog();

    _openDialog.Multiselect = false;

    _openDialog.Filter = "All Files|*.*";

    //show the file browser dialog to select file

    _openDialog.ShowDialog();

  

    if (_openDialog.File != null && _openDialog.File.Name != "")

    {

        string fileName = _openDialog.File.Name;

        Stream strm = _openDialog.File.OpenRead();

        UploadFile(strm, fileName);

    

    

    }

}

  

#region UploadFile

private void UploadFile(Stream strm, string fileName)

{

    byte[] buffer = new byte[strm.Length];

    strm.Read(buffer, 0, (int)strm.Length);

    strm.Close();

  

    UploadFile(buffer, fileName);

}

  

private void UploadFile(byte[] buffer, string fileName)

{

    UploadServiceClient client = new UploadServiceClient();

    client.UploadFileCompleted += ClientUploadFileCompleted;

  

    client.UploadFileAsync(fileName, buffer);

}

#endregion //UploadFile

  

  

  

#region ClientUploadFileCompleted

private void ClientUploadFileCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)

{

    if (e.Error == null)

    {

        MessageBox.Show(_openDialog.File.Name + ": Successfully Saved at ServerLocation");

  

        RefreshFilesList();

    }

    else

    {

        MessageBox.Show(e.Error.Message);

    }

}

#endregion //ClientUploadFileCompleted

  

  

#region RefreshFilesList

//Updates a list with file names from the server

private void RefreshFilesList()

{

    UploadServiceClient client = new UploadServiceClient();

  

    client.RefreshFileListCompleted -= ClientRefreshFileListCompleted;

    client.RefreshFileListCompleted += ClientRefreshFileListCompleted;

    client.RefreshFileListAsync();

    client.CloseAsync();

}

  

void ClientRefreshFileListCompleted(object sender, RefreshFileListCompletedEventArgs e)

{

  

    ObservableCollection<string> items = e.Result;

  

    this.FilesListBox.ItemsSource = items;

}

#endregion //RefreshFilesList

When download file from blob storage you need to save it in the Silverlight application Isolated Storage.

#region BtnDownloadClick

private void BtnDownloadClick(object sender, RoutedEventArgs e)

{ 

  

    if (this.FilesListBox.SelectedItem == null)

    {

        return;

    }

  

    string fileName = this.FilesListBox.SelectedItem.ToString();

  

    UploadServiceClient client = new UploadServiceClient();

  

    client.DownloadCompleted -= ClientDownloadCompleted;

  

    client.DownloadCompleted += ClientDownloadCompleted;

  

    client.DownloadAsync(fileName, fileName);

  

}

  

void ClientDownloadCompleted(object sender, DownloadCompletedEventArgs e)

{

    byte[] res = e.Result;

  

    string fileName = e.UserState.ToString();

  

    if (fileName != null)

    {

        WriteDataToStore(res, fileName);

    }

    

}

#endregion //BtnDownloadClick

#region WriteDataToStore

// Writes a file to an Isolated IStrorage, specified via its name 

// and content like a byte array

private void WriteDataToStore(byte[] data, string fileName)

{

    if (data == null || data.Length == 0)

        return;

    using (var store = IsolatedStorageFile.GetUserStoreForApplication())

    {

  

        IsolatedStorageFileStream fileStream = store.CreateFile(fileName);

        fileStream.Write(data, 0, data.Length);

        fileStream.Close();

  

    }

  

    RefreshIsoFilesList();

}

  

#endregion //WriteDataToStore

Implement shapefile loading from Isolated Storage to XamMap.

Shapefile is one of the first file formats, used to keep a spatial data.

More information about shapefile format you could find here:
http://en.wikipedia.org/wiki/Shapefile

Load the shape files from isolated storage using the ShapeFileReader:

You could redirect URI requests by registering custom prefixes in Silverlight.
The important line here being:

WebRequest.RegisterPrefix("iso",  

                    new IsoStorageRequestCreator());  

Which will register the iso:// prefix with our custom request creator.

More detailed information could be found in this post:

http://blogs.infragistics.com/forums/p/39754/224780.aspx

Create a new Windows Azure Storage Account and a Hosted Service

This sample will use Windows Azure simulator. Details, related with creating a Windows Azure Storage Account you could find in the article Migrating Spatial Data from SQL Server 2008 to SQL Azure

Add a Web Role project in Solution

When use a Windows Azure Emulator just set for Web Role settings for ConnectionString and DataConnectionString: “UseDevelopmentStorage=true”.

Edit settings in ServiceReferences.ClientConfig

<configuration>

    <system.serviceModel>

        <bindings>

            <customBinding>

                <binding name="CustomBinding_UploadService">

                    <binaryMessageEncoding />

                    <httpTransport maxReceivedMessageSize="2147483647" maxBufferSize="2147483647" />

                </binding>

            </customBinding>

        </bindings>

        <client>

                   

            <endpoint address="http://127.0.0.1:81/UploadService.svc"

                binding="customBinding" bindingConfiguration="CustomBinding_UploadService"

                contract="UploadService.UploadService" name="CustomBinding_UploadService" />

  

          <!--<endpoint address="http://localhost:37804/UploadService.svc"

                binding="customBinding" bindingConfiguration="CustomBinding_UploadService"

                contract="UploadService.UploadService" name="CustomBinding_UploadService" />-->

        </client>

    </system.serviceModel>

</configuration>

Run the demo application

Start the application

Upload files “cntry00.shp”, “cntry00.dbf” and “cntry00.shx” from local directory

Now parts of the shapefile are loaded in the blob storage.

Select each of the files from the blob storage and select “Download” button.
Now all files are saved in the Isolated Storage of the Silverlight application.

Select “Load from Iso” button to load shapefile.
Now data is loaded in the Infragistics XamMap component.

Navigate with the map. Enjoy! You have a working application that use a spatial data from Windows Azure blob storage.

Demo application you could download here: (Please visit the site to view this media):

Multi-Touch Simulation and Multi-Touch Behaviors for Windows Phone 7

[Infragistics] Mihail Mateev — Wed, 29 Dec 2010 23:39:00 GMT

When developing applications for Window Phone 7 is essential to realize the simulation of the Multi-Touch Activity for the applications. Currently, most computers do not have Multi-Touch Screens.
One very easy option is support for multiple mice. For this purpose you can find different solutions as Multimouse for Windows 7 or Multi-Touch Vista in codeplex. This article uses Multi-Touch Vista which is free and quite popular.

Installation of Multi-Touch Vista is presented in the magnificent art of Michael Sync "Installing Multi-Touch Simulator for Silverlight Phone 7”.

Sample application is based on sample for the article Creating Bing Maps Tile-Layers in Windows Phone 7

First the example will demonstrate how it works already Construction application for Windows Phone 7 c Multi-Touch Simulation with Multi-Touch Vista.
At the next stage will demonstrate how to use Multi-Touch Behaviors, developed by Laurent Bugnion (GalaSoft) and also presented in the article How to use the MultiTouch Behavior for Windows Phone 7.

Requirements:

Software:

Visual Studio 2010
Windows Phone Developer Tools
Windows Phone 7 Toolkit
Sample from the article Creating Bing Maps Tile-Layers in Windows Phone 7
Multi-Touch Vista
Silverlight 4, WPF 4 and Windows Phone 7 Multi-Touch Manipulation Project

Hardware:

Second USB Mouse

Step to reproduce:

Install required software
Build and start sample Windows Phone 7 application
Set up Multi-Touch Vista framework as it is described in the article ”Installing Multi-Touch Simulator for Silverlight Phone 7”
Start Multitouch.Service.Console.exe from Multi-Touch Vista framework.
Start Multitouch.Driver.Console.exe from the same package.
Switch to Thematic Maps Mobile application and make multi-touch zoom with a map.
Add Multi-Touch Behaviors in the Windows Phone 7 application
Rebuild and run the sample application.

Install required software

Build and start sample Windows Phone 7 application

Set up Multi-Touch Vista framework as it is described in the article ”Installing Multi-Touch Simulator for Silverlight Phone 7

Start Multitouch.Service.Console.exe from Multi-Touch Vista framework.

Start Multitouch.Driver.Console.exe from the same package (Multi-Touch Vista framework).

Switch to Thematic Maps Mobile application and make multi-touch zoom with a map.

Move both cursors to place it over the map

Drag with both mice in opposite directions to make zoom in and zoom out.

Stop Multitouch.Service.Console.exe pressing enter in the console

Add Multi-Touch Behaviors in the Windows Phone 7 application

Add a references to System.Windows.Interactivity and MultiTouch.Behaviors.WP7.dll in the ThematicMapsWindowPhone application:

Add Multi-Touch Behaviors in the Map component for translation, rotation and scaling.

<phone:PhoneApplicationPage 

    x:Class="ThematicMapsWindowPhone.Views.ThematicMapView"

    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    xmlns:phone="clr-namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone"

    xmlns:shell="clr-namespace:Microsoft.Phone.Shell;assembly=Microsoft.Phone"

    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

    mc:Ignorable="d" d:DesignWidth="480" d:DesignHeight="696"

    FontFamily="{StaticResource PhoneFontFamilyNormal}"

    FontSize="{StaticResource PhoneFontSizeNormal}"

    Foreground="{StaticResource PhoneForegroundBrush}"

    SupportedOrientations="PortraitOrLandscape"  Orientation="Portrait"

    shell:SystemTray.IsVisible="True"

    xmlns:interactivity="clr-namespace:MultiTouch.Behaviors.WP7;assembly=MultiTouch.Behaviors.WP7"

    xmlns:my="clr-namespace:Microsoft.Phone.Controls.Maps;assembly=Microsoft.Phone.Controls.Maps"

    xmlns:localcontrols="clr-namespace:ThematicMapsWindowPhone.Controls" 

    xmlns:Interactivity="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity">

  

    <!--LayoutRoot is the root grid where all page content is placed-->

    <Grid x:Name="LayoutRoot" Background="Transparent">

        <Grid.RowDefinitions>

            <RowDefinition Height="Auto"/>

            <RowDefinition Height="*"/>

        </Grid.RowDefinitions>

  

        <!--TitlePanel contains the name of the application and page title-->

        <StackPanel x:Name="TitlePanel" Grid.Row="0" Margin="12,17,0,28">

            <TextBlock x:Name="ApplicationTitle" Text="Thematic Maps Mobile" Style="{StaticResource PhoneTextNormalStyle}"/>

            <TextBlock x:Name="PageTitle" Text="Map View" Margin="9,-7,0,0" Style="{StaticResource PhoneTextTitle1Style}"/>

        </StackPanel>

  

        <!--ContentPanel - place additional content here-->

        <Grid x:Name="ContentPanel" Grid.Row="1" HorizontalAlignment="Stretch"

               VerticalAlignment="Stretch" Margin="12,0,12,0">

            <my:Map HorizontalAlignment="Stretch"  Name="MainMap" 

                    CredentialsProvider="AhyL1itKqs_HSBTekvefjurUR4O-eFGbahleUWXB5vB0e5zON9LSeWPwHghfQF_a"

                    VerticalAlignment="Stretch">

                <Interactivity:Interaction.Behaviors>

                    <interactivity:MultiTouchBehavior 

                               IsTranslateXEnabled="True" IsTranslateYEnabled="True"

                               IsRotateEnabled="True" 

                               IsScaleEnabled="True"

                               MinimumScale="3" MaximumScale="200"

                               AreFingersVisible="True"/>

                </Interactivity:Interaction.Behaviors>

                <my:Map.Children>

  

                    <my:MapTileLayer x:Name="layerCountries" Visibility="Collapsed" Opacity="0.7" >

                        <my:MapTileLayer.TileSources>

                            <my:LocationRectTileSource  ZoomRange="1,19" />

                        </my:MapTileLayer.TileSources>

                    </my:MapTileLayer>

                    <CheckBox x:Name="chkCountries"  Foreground="Black" VerticalAlignment="Bottom" 

                        HorizontalAlignment="Left" Content="Countries" 

                              Margin="5 5 5 70" IsChecked="False" 

                              Click="ChkCountriesClick"/>

                    <CheckBox x:Name="chkThematic" Foreground="Black" VerticalAlignment="Bottom" 

                        HorizontalAlignment="Left" Content="Thematic Tiles" 

                              Margin="5 5 5 10" IsChecked="False" 

                              Click="CheckBoxThematic_Click"/>

  

                    <Button x:Name="btnDefaultZoom" Foreground="Black" VerticalAlignment="Bottom" 

                        HorizontalAlignment="Right" Content="Default Zoom" 

                              Margin="5 5 5 20" Click="BtnDefaultZoomClick"/>

  

                    <Border  VerticalAlignment="Top" HorizontalAlignment="Right" Margin="0 13 10 0"  Opacity="0.8" BorderBrush="White" BorderThickness="2" CornerRadius="5">

                        <StackPanel Margin="10 12 10 10">

                            <!-- The TileLayer Radio button group. -->

                           <RadioButton Foreground="Black" Name="Population_rBtn" GroupName = "TileLayers" Content="Color By Population" FontSize="12" Checked="CheckBoxThematic_Click" />

                            <RadioButton Name="Area_rBtn" GroupName = "TileLayers" Content="Color By Area" Foreground="Black" FontSize="12" IsChecked="True" Checked="CheckBoxThematic_Click"/>

                        </StackPanel>

                    </Border>

                </my:Map.Children>

            </my:Map>

        </Grid>

  

        <Grid x:Name="Loading" Grid.RowSpan="2" HorizontalAlignment="Center" VerticalAlignment="Center" Visibility="Collapsed" >

            <localcontrols:Spinner x:Name="LoadSpinner" Canvas.ZIndex="100" Width="50" Height="50" Margin="5"/>

        </Grid>

    </Grid>

 

</phone:PhoneApplicationPage>

Repeat again steps from the first stage:

Start Multitouch.Service.Console.exe from Multi-Touch Vista framework.

Start Multitouch.Driver.Console.exe from the same package.

Switch to Thematic Maps Mobile application and make multi-touch interaction with a map.

Try to scale translate and rotate the map.

Enjoy! You have a multi-touch environment to test Windows Phone 7 applications. Multi-touch behaviors propose different transformations for selected control. You could test these behaviors using Multi- Touch Vista framework.

Source code of the demo application you could download here:(Please visit the site to view this media)

Creating Bing Maps Tile-Layers in Windows Phone 7

[Infragistics] Mihail Mateev — Mon, 27 Dec 2010 11:35:00 GMT

A few months ago I read a wonderful article by Johannes Kebeck “Creating Bing Maps Tile-Layers from SQL Server 2008 on the Fly” and DataConnector project in the codeplex. DataConnector project is focused on Bing Maps and SQL Server 2008 (and can also be easily used with SQL Azure). This allows organizations and developers to rapidly create web mapping applications that contain rich geospatial data visualization features. There is a sample with the Bing Maps Silverlight control, used to create a thematic maps, based on a spatial data in the SQL Server 2008. In the sample are demonstrated different ways to create a thematic map over a Bing Maps using MapLayers (vector data) and tile-layers (MapTileLayers).

When I started to deal with applications for Windows Phone 7 popped the question how to visualize geographic data. Microsoft offers Bing Maps control for Windows Phone 7.
I decided to try to create an application for Windows Phone, to create thematic maps on Bing Maps control as a tile-layers, using WCF service to create tiles of spatial data in SQL Server 2008 R2

Requirements:

Software:

Sample data:

Sample data is a database SampleGeographyData from DataConnector project, modified with a data for country populations.

Steps to reproduce:

Create a new Silverlight Windows Phone Application
Add a Bing Map component (Bing Map control) on the default page with a MapTileLayer inside it.
Restore a sample database, named SampleGeographyData
Add a WCF Service Application, named TileWcfService
Implement a logic to create a tiles with a color, based on a specific value.
Add UI controls to maintain thematic maps.
Create a class library, named Configuration and implement a logic to support external configuration in an app.config file.
Run the application

Create a new Silverlight Windows Phone Application

Add a Bing Map component (Bing Map control) on the default page with a MapTileLayer inside it.

Restore a sample database, named SampleGeographyData

Table countries contains fields NAME (the name of the country), POPULATION(the population of the country), the_geo(geometry type).

Fields NAME and POPULATION will be used to create criteria for thematic maps.

Add a WCF Service Application, named TileWcfService

Implement a logic to create a tiles with a color, based on a specific value.

ITile interface definition:

[ServiceContract]

public interface ITile

{

  

    /// <summary>

    /// ITile - Tile Interface

    /// </summary>

    /// <param name="table">string table - DB table to query</param>

    /// <param name="quadkey">string quadkey</param>

    /// <param name="thematicstr">string thematicstr - true || area || population</param>

    /// <returns>Stream - tile png</returns>

    [OperationContract]

    [WebGet(UriTemplate = "{table}/{quadkey}/{thematicstr}")]

  

    Stream GetTile(string table, string quadkey, string thematicstr);

}

Tile class definition:

public class Tile : ITile

{

    #region Member Variables

  

    /* global parameters */

    private string geomField = "the_geo"; // default name of Geography DataType column in tables

    private string srid = "4326"; // default name of SRID Constraint, EPSG:4326, of tables

    private int totalPoints = 0;

    private bool thematic = false;

    private int lvl;

    private int tileX;

    private int tileY;

    private int nwX;

    private int nwY;

    private double nwLon;

    private double nwLat;

    private double seLon;

    private double seLat;

    private int pixelX;

    private int pixelY;

    private Dictionary<string, LoadStyle> LayerStyle = new Dictionary<string, LoadStyle>();

  

    //8 color values in thematic range

    private string[] colorRange = new string[] { "#FF400000", "#FF804040", "#FFC04000", "#FFC08080", "#FFFF0000", "#FFFF8040", "#FFFFC080", "#FFFFFF80" };

  

  

    #endregion //Member Variables

  

    ////Dummy default method

    //public void DoWork()

    //{

    //}

  

    /// <summary>

    /// Get png tile 

    /// </summary>

    /// <param name="table">layer table to use</param>

    /// <param name="quadkey">quadkey for current tile</param>

    /// <param name="thematicstr">string true or false - thematic styling</param>

    /// <returns>png stream</returns>

    /// <remarks>

    ///   webHttp uses RESTful urel format

    ///   thematic map selection does not use caching

    /// </remarks>

    public Stream GetTile(string table, string quadkey, string thematicstr)

    {

        DateTime queryStart = DateTime.Now;

        DateTime queryStop;

  

        //1281396894

        //LoadStyle - stroke, fill, opacity, pointRadius, valueCol, maxValue, skew factor

        if (thematicstr.Equals("population"))

        {

            LayerStyle.Add("countries", new LoadStyle("#FFFF0000", "#FF00FF00", 0.25, 1, "POPULATION", 1281396.894, 128.0));

        }

        else if (thematicstr.Equals("area"))

        {

            LayerStyle.Add("countries", new LoadStyle("#FFFF0000", "#FF00FF00", 0.25, 1, "AREA", 6043.6, 128.0));

           // LayerStyle.Add("countries", new LoadStyle("#FFFF0000", "#FF00FF00", 0.25, 1, "POPULATION", 1281396.894, 128.0));

        }

  

        LayerStyle.Add("statesprovinces", new LoadStyle("#FFFF0000", "#FF0000FF", 0.25, 1, "AREA", 321.6, 128.0));

        LayerStyle.Add("uscounties", new LoadStyle("#FFFF0000", "#FF00FFFF", 0.25, 2, "AREA", 74.22, 512.0));

        LayerStyle.Add("faults", new LoadStyle("#FFFF0000", "#FF000000", 1.0, 2, "ACODE", 6, 8.0));

        LayerStyle.Add("earthquakes", new LoadStyle("#FFFF0000", "#FFFFFF00", 1.0, 12, "OTHER_MAG1", 9.24, 10.0));

  

        thematic = !thematicstr.ToLower().Equals("false");

        Encoding encoding = new UTF8Encoding();

        Bitmap tileBitmap = new Bitmap(256, 256, PixelFormat.Format32bppArgb);

        Graphics g = Graphics.FromImage(tileBitmap);

        string connStr = ConfigurationManager.ConnectionStrings["DataConnectionString"].ConnectionString;

        SqlConnection conn = new SqlConnection(connStr);

        SqlDataReader rdr = null;

        try

        {

            conn.Open();

            MemoryStream imageAsMemoryStream = new MemoryStream();

            if (!thematic && isCached(table, quadkey, conn))

            {

                // get cached tile from table blob

                imageAsMemoryStream = GetCachedTile(table, quadkey, conn);

            }

            else

            {

                //build tile since it is not in tile table or this is thematic map

                StringBuilder query = new StringBuilder("SELECT ID," + LayerStyle[table].valueCol + "," + geomField + ".Reduce(@reduce) as " + geomField + " FROM [dbo].[" + table + "] WITH(INDEX(the_geo_sidx)) WHERE ");

                query.Append(geomField + ".STIntersects(geography::STGeomFromText('POLYGON(('+@nwLon+' '+@nwLat+', '+@nwLon+' '+@seLat+', '+@seLon+' '+@seLat+', '+@seLon+' '+@nwLat+', '+@nwLon+' '+@nwLat+'))', @srid))=1");

                

                lvl = quadkey.Length;

                double reduce = int.Parse(ConfigurationSettings.AppSettings["reduceMax"]) - (lvl * 2000);

                if (reduce < 0) reduce = 0;

  

                QuadKeyToTileXY(quadkey, out tileX, out tileY, out lvl);

                TileXYToPixelXY(tileX, tileY, out nwX, out nwY);

  

                PixelXYToLatLong(nwX, nwY, lvl, out nwLat, out nwLon);

                PixelXYToLatLong(nwX + 256, nwY + 256, lvl, out seLat, out seLon);

                if (nwLon == -180.0) nwLon = -179.9;

                queryStart = DateTime.Now;

                SqlCommand cmd = new SqlCommand(query.ToString(), conn);

                cmd.Parameters.Add(new SqlParameter("reduce", reduce));

                cmd.Parameters.Add(new SqlParameter("srid", srid));

                cmd.Parameters.Add(new SqlParameter("nwLon", nwLon.ToString()));

                cmd.Parameters.Add(new SqlParameter("nwLat", nwLat.ToString()));

                cmd.Parameters.Add(new SqlParameter("seLon", seLon.ToString()));

                cmd.Parameters.Add(new SqlParameter("seLat", seLat.ToString()));

                //log.Info(query.ToString());

                //log.Info(quadkey + " reduce=" + reduce + " srid=" + srid + " nwLon=" + nwLon + " nwLat=" + nwLat + " seLon=" + seLon + " seLat=" + seLat);

  

                rdr = cmd.ExecuteReader();

  

                while (rdr.Read())

                {

                    double value = 1.0;

                    Color color = Color.White;

                    if (thematic) // thematic color by colValue range

                    {

                        try

                        {

                            value = double.Parse(rdr[LayerStyle[table].valueCol].ToString()) / LayerStyle[table].maxValue;

                        }

                        catch (Exception e)

                        {

                            value = 1.0;

                        }

                        for (int i = 1; i < colorRange.Length; i++)

                        {

                            if (value < (i / (LayerStyle[table].skewFactor)))

                            {

                                color = ColorFromInt(colorRange[i - 1]);

                                break;

                            }

                            else color = ColorFromInt(colorRange[colorRange.Length - 1]);

                        }

                    }

  

                    SqlGeography geo = (SqlGeography)rdr[geomField];

                    //log.Debug(geo.STGeometryType().ToString().ToUpper());

                    switch (geo.STGeometryType().ToString().ToUpper())

                    {

                        case "POINT":

                            {

                                RenderPoint(geo, table, g, color);

                                break;

                            }

                        case "LINESTRING":

                            {

                                RenderLinestring(geo, table, g, (int)rdr["ID"], color);

                                break;

                            }

                        case "POLYGON":

                            {

                                RenderPolygon(geo, table, g, (int)rdr["ID"], color);

                                break;

                            }

                        case "MULTILINESTRING":

                            {

                                RenderMultiLinestring(geo, table, g, (int)rdr["ID"], color);

                                break;

                            }

                        case "MULTIPOLYGON":

                            {

                                RenderMultiPolygon(geo, table, g, (int)rdr["ID"], color);

                                break;

                            }

                        case "GEOMETRYCOLLECTION":

                            {

                                RenderGeometryCollection(geo, table, g, (int)rdr["ID"], color);

                                break;

                            }

                    }

  

                }

                queryStop = DateTime.Now;

                //log.Debug(String.Format("Query Time: {0,0:0}ms", (queryStop - queryStart).TotalMilliseconds));

  

                tileBitmap.Save(imageAsMemoryStream, ImageFormat.Png);

                if (rdr != null) rdr.Close();

  

                if (!thematic && !isCached(table, quadkey, conn))

                {

                    // cache tile to table blob

                    int iresult = SetCachedTile(table, quadkey, imageAsMemoryStream, conn);

                }

            }

  

            imageAsMemoryStream.Position = 0;

            tileBitmap.Dispose();

            return imageAsMemoryStream;

        }

        catch (Exception e)

        {

            //log.Error(e.Message);

        }

        finally

        {

            if (rdr != null) rdr.Close();

            if (conn != null) conn.Close();

        }

        Assembly thisExe = Assembly.GetExecutingAssembly();

        return thisExe.GetManifestResourceStream("TileWcfService.empty.png");

    }

  

    /// <summary>

    /// isCached

    ///     determines if a cached tile exists in the tileTable

    /// </summary>

    /// <param name="table">string layer table</param>

    /// <param name="quadkey">string current quadkey</param>

    /// <param name="conn"> SQL Server Connection</param>

    /// <returns>bool true if tile exists in table</returns>

    private bool isCached(string table, string quadkey, SqlConnection conn)

    {

        bool cached = false;

        SqlCommand cmd = new SqlCommand("Select count(*) FROM tile" + table + " WHERE quadkey=@quadkey", conn);

        cmd.Parameters.Add(new SqlParameter("quadkey", quadkey));

  

        int cnt = (int)cmd.ExecuteScalar();

        if (cnt > 0) cached = true;

        return cached;

    }

  

    /// <summary>

    /// GetCachedTile

    ///     returns a tile from caching tileTable

    /// </summary>

    /// <param name="table">string layer table</param>

    /// <param name="quadkey">string current quadkey</param>

    /// <param name="conn"> SQL Server Connection</param>

    /// <returns>png stream</returns>

    private MemoryStream GetCachedTile(string table, string quadkey, SqlConnection conn)

    {

        SqlCommand cmdSelect = new SqlCommand("SELECT tile FROM tile" + table + " WHERE quadkey=@quadkey", conn);

        cmdSelect.Parameters.Add(new SqlParameter("quadkey", quadkey));

  

        byte[] image = (byte[])cmdSelect.ExecuteScalar();

        MemoryStream imageStream = new MemoryStream();

        imageStream.Write(image, 0, image.Length);

        return imageStream;

    }

  

    /// <summary>

    /// SetCachedTile

    ///     Adds tile png to caching tileTable

    /// </summary>

    /// <param name="table">string layer table</param>

    /// <param name="quadkey">string current quadkey</param>

    /// <param name="imageStream">MemorySTream of png tile</param>

    /// <param name="conn"> SQL Server Connection</param>

    /// <returns>int ExecuteNonQuery() return</returns>

    private int SetCachedTile(string table, string quadkey, MemoryStream imageStream, SqlConnection conn)

    {

  

        imageStream.Position = 0;

        byte[] imageData = new byte[imageStream.Length];

        imageStream.Read(imageData, 0, (int)imageStream.Length);

  

        SqlCommand cmd = new SqlCommand("INSERT INTO tile" + table + "(quadkey,tile) values(@quadkey,@tile)", conn);

        cmd.Parameters.Add(new SqlParameter("quadkey", quadkey));

        cmd.Parameters.Add("@tile", SqlDbType.Image);

        cmd.Parameters["@tile"].Value = imageData;

        return cmd.ExecuteNonQuery();

    }

  

  

    #region render geography

    /// <summary>

    /// RenderPoint

    ///     Render a point to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="valueFill">Color the fill color style</param>

    private void RenderPoint(SqlGeography geo, string table, Graphics g, Color valueFill)

    {

        totalPoints++;

        double lat = (double)geo.Lat;

        double lon = (double)geo.Long;

        LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

        Point cp = new Point(pixelX - nwX, pixelY - nwY);

        if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

        SolidBrush myBrush = new SolidBrush(valueFill);

        int r = LayerStyle[table].pointRadius;

        g.FillEllipse(myBrush, new Rectangle(cp.X - r / 2, cp.Y - r / 2, r, r));

    }

  

    /// <summary>

    /// RenderLinestring

    ///     Render a linestring to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="valueFill">Color the stroke color style</param>

    private void RenderLinestring(SqlGeography geo, string table, Graphics g, int id, Color valueFill)

    {

        if (geo.STNumPoints() > 1)

        {

            totalPoints += (int)geo.STNumPoints();

            Point[] ptArray = new Point[(int)geo.STNumPoints()];

            double lon1 = 0.0;

            for (int j = 1; j <= geo.STNumPoints(); j++)

            {

                double lat = (double)geo.STPointN(j).Lat;

                double lon = (double)geo.STPointN(j).Long;

                if (j > 1)

                {

                    lon = HemisphereCorrection(lon, lon1, id);

                }

                LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

                ptArray[j - 1] = new Point(pixelX - nwX, pixelY - nwY);

                lon1 = lon;

            }

            if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

            GraphicsPath linePath = new GraphicsPath();

            linePath.AddLines(ptArray);

            Pen myPen = new Pen(valueFill);

            myPen.Width = 2;

            g.DrawPath(myPen, linePath);

        }

  

    }

  

    /// <summary>

    /// RenderPolygon

    ///     Render a polygon to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="valueFill">Color the fill color style</param>

    private void RenderPolygon(SqlGeography geo, string table, Graphics g, int id, Color valueFill)

    {

  

        if (geo.NumRings() > 0)

        {

            totalPoints += (int)geo.STNumPoints();

            for (int j = 1; j <= geo.NumRings(); j++)

            {

                if (geo.RingN(j).STNumPoints() > 1)

                {

                    Point[] ptArray = new Point[(int)geo.RingN(j).STNumPoints()];

                    double lon1 = 0.0;

                    for (int k = 1; k <= geo.RingN(j).STNumPoints(); k++)

                    {

                        double lat = (double)geo.RingN(j).STPointN(k).Lat;

                        double lon = (double)geo.RingN(j).STPointN(k).Long;

                        if (k > 1)

                        {

                            lon = HemisphereCorrection(lon, lon1, id);

                        }

                        LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

                        ptArray[k - 1] = new Point(pixelX - nwX, pixelY - nwY);

                        lon1 = lon;

                    }

                    if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

                    GraphicsPath polygonRegion = new GraphicsPath();

                    polygonRegion.AddPolygon(ptArray);

                    Region region = new Region(polygonRegion);

  

                    SolidBrush myBrush = new SolidBrush(valueFill);

                    g.FillRegion(myBrush, region);

                    Pen myPen = new Pen(ColorFromInt(LayerStyle[table].stroke));

                    myPen.Width = 1;

                    g.DrawPolygon(myPen, ptArray);

                }

            }

  

        }

  

    }

  

    /// <summary>

    /// RenderMultiLinestring

    ///     Render a MultiLinestring to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="id">int record id</param>

    /// <param name="valueFill">Color the stroke color style</param>

    private void RenderMultiLinestring(SqlGeography geo, string table, Graphics g, int id, Color valueFill)

    {

  

        if (geo.STNumGeometries() > 0)

        {

            totalPoints += (int)geo.STNumPoints();

  

            for (int j = 1; j <= geo.STNumGeometries(); j++)

            {

                if (geo.STGeometryN(j).NumRings() > 0)

                {

                    for (int k = 1; k <= geo.STGeometryN(j).NumRings(); k++)

                    {

                        if (geo.STGeometryN(j).RingN(k).STNumPoints() > 1)

                        {

                            Point[] ptArray = new Point[(int)geo.STNumPoints()];

                            double lon1 = 0.0;

                            for (int m = 1; m <= geo.STGeometryN(j).RingN(k).STNumPoints(); m++)

                            {

                                double lat = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Lat;

                                double lon = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Long;

                                if (m > 1)

                                {

                                    lon = HemisphereCorrection(lon, lon1, id);

                                }

                                LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

                                ptArray[m - 1] = new Point(pixelX - nwX, pixelY - nwY);

                                lon1 = lon;

                            }

                            if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

                            GraphicsPath linePath = new GraphicsPath();

                            linePath.AddLines(ptArray);

                            Pen myPen = new Pen(valueFill);

                            myPen.Width = 2;

                            g.DrawPath(myPen, linePath);

                        }

                    }

                }

            }

  

        }

  

    }

  

    /// <summary>

    /// RenderMultiPolygon

    ///     Render a Multipolygon to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="id">int record id</param>

    /// <param name="valueFill">Color the fill color style</param>

    private void RenderMultiPolygon(SqlGeography geo, string table, Graphics g, int id, Color valueFill)

    {

  

        if (geo.STNumGeometries() > 0)

        {

            totalPoints += (int)geo.STNumPoints();

  

            for (int j = 1; j <= geo.STNumGeometries(); j++)

            {

                if (geo.STGeometryN(j).NumRings() > 0)

                {

                    for (int k = 1; k <= geo.STGeometryN(j).NumRings(); k++)

                    {

                        if (geo.STGeometryN(j).RingN(k).STNumPoints() > 1)

                        {

                            Point[] ptArray = new Point[(int)geo.STGeometryN(j).RingN(k).STNumPoints()];

                            double lon1 = 0.0;

                            int count = (int)geo.STGeometryN(j).RingN(k).STNumPoints();

                            for (int m = 1; m <= geo.STGeometryN(j).RingN(k).STNumPoints(); m++)

                            {

                                double lat = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Lat;

                                double lon = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Long;

                                if (m > 1)

                                {

                                    lon = HemisphereCorrection(lon, lon1, id);

                                }

                                LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

                                ptArray[m - 1] = new Point(pixelX - nwX, pixelY - nwY);

                                lon1 = lon;

                            }

                            if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

                            GraphicsPath polygonRegion = new GraphicsPath();

                            polygonRegion.AddPolygon(ptArray);

                            Region region = new Region(polygonRegion);

  

                            g.FillRegion(new SolidBrush(valueFill), region);

                            Pen myPen = new Pen(ColorFromInt(LayerStyle[table].stroke));

                            myPen.Width = 1;

                            g.DrawPolygon(myPen, ptArray);

                        }

                    }

                }

            }

        }

  

    }

  

  

    /// <summary>

    /// RenderGeometryCollection

    ///     Render a GeometryCollection to Graphics

    /// </summary>

    /// <param name="geo">SqlGeography geo</param>

    /// <param name="table">string layer table</param>

    /// <param name="g">Graphics used to draw to</param>

    /// <param name="id">int record id</param>

    /// <param name="valueFill">Color the fill color style</param>

    private void RenderGeometryCollection(SqlGeography geo, string table, Graphics g, int id, Color valueFill)

    {

        int numGeom = (int)geo.STNumGeometries();

        if (geo.STNumGeometries() > 0)

        {

            for (int j = 1; j <= geo.STNumGeometries(); j++)

            {

                if (geo.STGeometryN(j).NumRings() > 0)

                {

                    for (int k = 1; k <= geo.STGeometryN(j).NumRings(); k++)

                    {

                        if (geo.STGeometryN(j).RingN(k).STNumPoints() > 1)

                        {

                            double lon1 = 0.0;

                            Point[] ptArray = new Point[(int)geo.STGeometryN(j).RingN(k).STNumPoints()];

                            for (int m = 1; m <= geo.STGeometryN(j).RingN(k).STNumPoints(); m++)

                            {

                                double lat = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Lat;

                                double lon = (double)geo.STGeometryN(j).RingN(k).STPointN(m).Long;

  

                                if (m > 1)

                                {

                                    lon = HemisphereCorrection(lon, lon1, id);

                                }

  

                                LatLongToPixelXY(lat, lon, lvl, out pixelX, out pixelY);

                                ptArray[m - 1] = new Point(pixelX - nwX, pixelY - nwY);

                                lon1 = lon;

                            }

                            if (valueFill.Equals(Color.White)) valueFill = ColorFromInt(LayerStyle[table].fill);

                            GraphicsPath extRingRegion = new GraphicsPath();

                            extRingRegion.AddPolygon(ptArray);

                            Region region = new Region(extRingRegion);

                            g.FillRegion(new SolidBrush(valueFill), region);

                            Pen myPen = new Pen(ColorFromInt(LayerStyle[table].stroke));

                            myPen.Width = 1;

                            g.DrawPolygon(myPen, ptArray);

                        }

                    }

                }

            }

        }

    }

  

    /// <summary>

    /// HemisphereCorrection

    ///     attempts to correct polygons crossing International Dataline

    /// </summary>

    /// <param name="lon"></param>

    /// <param name="lon1"></param>

    /// <param name="id"></param>

    /// <returns></returns>

    private double HemisphereCorrection(double lon, double lon1, int id)

    {

        //truncate polygon to nearest hemisphere boundary

        if ((lon < 0.0 && lon1 > 0.0) || (lon > 0.0 && lon1 < 0.0))

        { // crosses hemisphere - use shorter of distances to opposite hemisphere boundaries

            //log.Debug("Crosses Hemisphere: " + lon + " " + lon1 + " id=" + id);

            double d1 = Math.Abs(lon1 - 180);

            double d2 = Math.Abs(lon1 - 0.0);

            if (lon1 > 0)

            {

                if (d1 < d2) lon = 180.0;

                else lon = 0.0;

            }

            else

            {

                if (d1 < d2) lon = -180.0;

                else lon = 0.0;

            }

        }

        return lon;

    }

  

  

    #endregion

  

    #region Helper Functions

  

  

  

    /// <summary>

    /// Clips a number to the specified minimum and maximum values.

    /// </summary>

    /// <param name="n">The number to clip.</param>

    /// <param name="minValue">Minimum allowable value.</param>

    /// <param name="maxValue">Maximum allowable value.</param>

    /// <returns>The clipped value.</returns>

    /// <remarks>

    ///     Most helper functions are from MSDN site:

    ///     http://msdn.microsoft.com/en-us/library/bb259689.aspx

    ///</remarks>

    private static double Clip(double n, double minValue, double maxValue)

    {

        return Math.Min(Math.Max(n, minValue), maxValue);

    }

  

  

  

    /// <summary>

    /// Determines the map width and height (in pixels) at a specified level

    /// of detail.

    /// </summary>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <returns>The map width and height in pixels.</returns>

    public static uint MapSize(int levelOfDetail)

    {

        return (uint)256 << levelOfDetail;

    }

  

  

  

    /// <summary>

    /// Determines the ground resolution (in meters per pixel) at a specified

    /// latitude and level of detail.

    /// </summary>

    /// <param name="latitude">Latitude (in degrees) at which to measure the

    /// ground resolution.</param>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <returns>The ground resolution, in meters per pixel.</returns>

    public static double GroundResolution(double latitude, int levelOfDetail)

    {

        latitude = Clip(latitude, MinLatitude, MaxLatitude);

        return Math.Cos(latitude * Math.PI / 180) * 2 * Math.PI * EarthRadius / MapSize(levelOfDetail);

    }

  

  

  

    /// <summary>

    /// Determines the map scale at a specified latitude, level of detail,

    /// and screen resolution.

    /// </summary>

    /// <param name="latitude">Latitude (in degrees) at which to measure the

    /// map scale.</param>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <param name="screenDpi">Resolution of the screen, in dots per inch.</param>

    /// <returns>The map scale, expressed as the denominator N of the ratio 1 : N.</returns>

    public static double MapScale(double latitude, int levelOfDetail, int screenDpi)

    {

        return GroundResolution(latitude, levelOfDetail) * screenDpi / 0.0254;

    }

  

  

  

    /// <summary>

    /// Converts a point from latitude/longitude WGS-84 coordinates (in degrees)

    /// into pixel XY coordinates at a specified level of detail.

    /// </summary>

    /// <param name="latitude">Latitude of the point, in degrees.</param>

    /// <param name="longitude">Longitude of the point, in degrees.</param>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <param name="pixelX">Output parameter receiving the X coordinate in pixels.</param>

    /// <param name="pixelY">Output parameter receiving the Y coordinate in pixels.</param>

    public static void LatLongToPixelXY(double latitude, double longitude, int levelOfDetail, out int pixelX, out int pixelY)

    {

        latitude = Clip(latitude, MinLatitude, MaxLatitude);

        longitude = Clip(longitude, MinLongitude, MaxLongitude);

  

        double x = (longitude + 180) / 360;

        double sinLatitude = Math.Sin(latitude * Math.PI / 180);

        double y = 0.5 - Math.Log((1 + sinLatitude) / (1 - sinLatitude)) / (4 * Math.PI);

  

        uint mapSize = MapSize(levelOfDetail);

        pixelX = (int)Clip(x * mapSize + 0.5, 0, mapSize - 1);

        pixelY = (int)Clip(y * mapSize + 0.5, 0, mapSize - 1);

    }

  

  

  

    /// <summary>

    /// Converts a pixel from pixel XY coordinates at a specified level of detail

    /// into latitude/longitude WGS-84 coordinates (in degrees).

    /// </summary>

    /// <param name="pixelX">X coordinate of the point, in pixels.</param>

    /// <param name="pixelY">Y coordinates of the point, in pixels.</param>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <param name="latitude">Output parameter receiving the latitude in degrees.</param>

    /// <param name="longitude">Output parameter receiving the longitude in degrees.</param>

    public static void PixelXYToLatLong(int pixelX, int pixelY, int levelOfDetail, out double latitude, out double longitude)

    {

        double mapSize = MapSize(levelOfDetail);

        double x = (Clip(pixelX, 0, mapSize - 1) / mapSize) - 0.5;

        double y = 0.5 - (Clip(pixelY, 0, mapSize - 1) / mapSize);

  

        latitude = 90 - 360 * Math.Atan(Math.Exp(-y * 2 * Math.PI)) / Math.PI;

        longitude = 360 * x;

    }

  

    private const double EarthRadius = 6378137;

    private const double MinLatitude = -85.05112878;

    private const double MaxLatitude = 85.05112878;

    private const double MinLongitude = -180;

    private const double MaxLongitude = 180;

  

    /// <summary>

    /// Converts pixel XY coordinates into tile XY coordinates of the tile containing

    /// the specified pixel.

    /// </summary>

    /// <param name="pixelX">Pixel X coordinate.</param>

    /// <param name="pixelY">Pixel Y coordinate.</param>

    /// <param name="tileX">Output parameter receiving the tile X coordinate.</param>

    /// <param name="tileY">Output parameter receiving the tile Y coordinate.</param>

    public static void PixelXYToTileXY(int pixelX, int pixelY, out int tileX, out int tileY)

    {

        tileX = pixelX / 256;

        tileY = pixelY / 256;

    }

  

  

  

    /// <summary>

    /// Converts tile XY coordinates into pixel XY coordinates of the upper-left pixel

    /// of the specified tile.

    /// </summary>

    /// <param name="tileX">Tile X coordinate.</param>

    /// <param name="tileY">Tile Y coordinate.</param>

    /// <param name="pixelX">Output parameter receiving the pixel X coordinate.</param>

    /// <param name="pixelY">Output parameter receiving the pixel Y coordinate.</param>

    public static void TileXYToPixelXY(int tileX, int tileY, out int pixelX, out int pixelY)

    {

        pixelX = tileX * 256;

        pixelY = tileY * 256;

    }

  

  

  

    /// <summary>

    /// Converts tile XY coordinates into a QuadKey at a specified level of detail.

    /// </summary>

    /// <param name="tileX">Tile X coordinate.</param>

    /// <param name="tileY">Tile Y coordinate.</param>

    /// <param name="levelOfDetail">Level of detail, from 1 (lowest detail)

    /// to 23 (highest detail).</param>

    /// <returns>A string containing the QuadKey.</returns>

    public static string TileXYToQuadKey(int tileX, int tileY, int levelOfDetail)

    {

        StringBuilder quadKey = new StringBuilder();

        for (int i = levelOfDetail; i > 0; i--)

        {

            char digit = '0';

            int mask = 1 << (i - 1);

            if ((tileX & mask) != 0)

            {

                digit++;

            }

            if ((tileY & mask) != 0)

            {

                digit++;

                digit++;

            }

            quadKey.Append(digit);

        }

        return quadKey.ToString();

    }

  

  

    /// <summary>

    /// Converts a QuadKey into tile XY coordinates.

    /// </summary>

    /// <param name="quadKey">QuadKey of the tile.</param>

    /// <param name="tileX">Output parameter receiving the tile X coordinate.</param>

    /// <param name="tileY">Output parameter receiving the tile Y coordinate.</param>

    /// <param name="levelOfDetail">Output parameter receiving the level of detail.</param>

    public static void QuadKeyToTileXY(string quadKey, out int tileX, out int tileY, out int levelOfDetail)

    {

        tileX = tileY = 0;

        levelOfDetail = quadKey.Length;

        for (int i = levelOfDetail; i > 0; i--)

        {

            int mask = 1 << (i - 1);

            switch (quadKey[levelOfDetail - i])

            {

                case '0':

                    break;

  

                case '1':

                    tileX |= mask;

                    break;

  

                case '2':

                    tileY |= mask;

                    break;

  

                case '3':

                    tileX |= mask;

                    tileY |= mask;

                    break;

  

                default:

                    throw new ArgumentException("Invalid QuadKey digit sequence.");

            }

        }

    }

  

    /// <summary>

    /// ColorFromInt

    /// Returns a Color from hex string i.e. #FF00FF00

    /// </summary>

    /// <param name="hex">string hex color with alpha, red, green, blue</param>

    /// <returns>Color</returns>

    private Color ColorFromInt(string hex)

    {

        if (hex.StartsWith("#")) hex = hex.Substring(1);

        int c = int.Parse(hex, NumberStyles.AllowHexSpecifier);

        return Color.FromArgb((byte)((c >> 0x18) & 0xff),

            (byte)((c >> 0x10) & 0xff),

            (byte)((c >> 8) & 0xff),

            (byte)(c & 0xff));

    }

  

  

    /// <summary>

    /// Returns a random color

    /// </summary>

    /// <returns></returns>

    public static Color RandomColor()

    {

        Random randomSeed = new Random();

        return Color.FromArgb(

            randomSeed.Next(256),

            randomSeed.Next(256),

            randomSeed.Next(256)

        );

    }

  

  

    #endregion

  

}

Add UI controls to maintain thematic maps.

<Grid x:Name="ContentPanel" Grid.Row="1" HorizontalAlignment="Stretch"

       VerticalAlignment="Stretch" Margin="12,0,12,0">

    <my:Map HorizontalAlignment="Stretch"  Name="MainMap" 

            CredentialsProvider="AhyL1itKqs_HSBTekvefjurUR4O-eFGbahleUWXB5vB0e5zON9LSeWPwHghfQF_a"

            VerticalAlignment="Stretch">

        <my:Map.Children>

  

            <my:MapTileLayer x:Name="layerCountries" Visibility="Collapsed" Opacity="0.7" >

                <my:MapTileLayer.TileSources>

                    <my:LocationRectTileSource  ZoomRange="1,19" />

                </my:MapTileLayer.TileSources>

            </my:MapTileLayer>

            <CheckBox x:Name="chkCountries"  Foreground="Black" VerticalAlignment="Bottom" 

                HorizontalAlignment="Left" Content="Countries" 

                      Margin="5 5 5 70" IsChecked="False" 

                      Click="ChkCountriesClick"/>

            <CheckBox x:Name="chkThematic" Foreground="Black" VerticalAlignment="Bottom" 

                HorizontalAlignment="Left" Content="Thematic Tiles" 

                      Margin="5 5 5 10" IsChecked="False" 

                      Click="CheckBoxThematic_Click"/>

  

            <Button x:Name="btnDefaultZoom" Foreground="Black" VerticalAlignment="Bottom" 

                HorizontalAlignment="Right" Content="Default Zoom" 

                      Margin="5 5 5 20" Click="BtnDefaultZoomClick"/>

  

            <Border  VerticalAlignment="Top" HorizontalAlignment="Right" Margin="0 13 10 0"  Opacity="0.8" BorderBrush="White" BorderThickness="2" CornerRadius="5">

                <StackPanel Margin="10 12 10 10">

                    <!-- The TileLayer Radio button group. -->

                   <RadioButton Foreground="Black" Name="Population_rBtn" GroupName = "TileLayers" Content="Color By Population" FontSize="12" Checked="CheckBoxThematic_Click" />

                    <RadioButton Name="Area_rBtn" GroupName = "TileLayers" Content="Color By Area" Foreground="Black" FontSize="12" IsChecked="True" Checked="CheckBoxThematic_Click"/>

                </StackPanel>

            </Border>

        </my:Map.Children>

    </my:Map>

</Grid>

Implement a code in en event handler , called when you need to turn on / off generation of the tiles.

#region ChkCountriesClick

private void ChkCountriesClick(object sender, RoutedEventArgs e)

{

    var cb = sender as CheckBox;

    const string layerName = "layerCountries";

    if (cb != null)

        if ((bool)cb.IsChecked)

        {

            //Layer Checked

            //initiate a map ViewChange event

            if (MainMap.FindName(layerName).GetType().Equals(typeof(MapTileLayer)))

            {   //tiles 

                ((MapTileLayer)MainMap.FindName(layerName)).Visibility = Visibility.Visible;

            }

  

            CheckBoxThematic_Click(this.chkThematic, null);

  

            MainMap.SetView(MainMap.Center, MainMap.ZoomLevel);

  

  

        }

        else

        {

            //Layer Unchecked

            if (MainMap.FindName(layerName).GetType().Equals(typeof(MapTileLayer)))

            {   //tiles 

                ((MapTileLayer)MainMap.FindName(layerName)).Visibility = Visibility.Collapsed;

            }

        }

}

#endregion //ChkCountriesClick

#region CheckBoxThematic_Click

private void CheckBoxThematic_Click(object sender, RoutedEventArgs e)

{

    var cb = sender as CheckBox;

    var rb = sender as RadioButton;

  

    if (this.Area_rBtn == null || this.Population_rBtn == null)

    {

        return;

    }

  

    if ((cb != null && (bool)cb.IsChecked) || ((rb != null && (bool)rb.IsChecked) && (bool)this.chkThematic.IsChecked))

    {

  

        if (this.Area_rBtn.IsChecked == true)

        {

            SetMapTileLayers("area");

        }

        else if (this.Population_rBtn.IsChecked == true)

        {

            SetMapTileLayers("population");

        }

  

  

    }

    else

    {

        SetMapTileLayers("false");

    }

}

#endregion //CheckBoxThematic_Click

Implement method SetMapTileLayers that sets UriFormat to MapTileLayer to use WCF service that returns tiles:

#region SetMapTileLayers

private void SetMapTileLayers(string thematicstr)

{

    foreach (UIElement item in MainMap.Children)

    {

        if (item is MapTileLayer)

        {

            MapTileLayer mtile = item as MapTileLayer;

            string layer = mtile.Name;

            foreach (LocationRectTileSource tilesource in mtile.TileSources)

            {

                tilesource.UriFormat = "http://localhost:23024/Services/Tile.svc/" + layer.Replace("layer", "").ToLower() + "/{quadkey}/" + thematicstr;

            }

        }

    }

}

#endregion //SetMapTileLayers

Create a class library, named Configuration and implement a logic to support external configuration in an app.config file.

When developing applications it is always a good idea not to hardcode database connections, URLs, server locations, etc... In .NET there's the Configuration stack that allows us to use the app.config xml file. This functionality is not supported in Silverlight as well as in the Windows Phone 7.

In Alex Yakhnin's Blog there is an article with a sample how to implement Mobile Application Blocks that includes the Configuration block (sample code is ported from Windows Mobile 6.x to Windows Phone 7).

Then you add app.config file to your project and make sure that it has the the Build Action set to "Content".

app.config file

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

  <configSections>

    <section name="ApplicationSettings"  type="Configuration.ApplicationSettingsSection,ThematicMapsWindowPhone" />

  </configSections>

  

  <ApplicationSettings>

    <appSettings>

      <add key="remoteServer" value="http://localhost:23024/Services/Tile.svc/"/>

    </appSettings>

  </ApplicationSettings>

  

</configuration>

The last step is to add the code that reads the values from this configuration file: add an ApplicationSettingsSection to read values from app.config and modify SetMapTileLayers method to use a WCF host and port from this file:

namespace ThematicMapsWindowPhone.Views

{

    public partial class ThematicMapView : PhoneApplicationPage

    {

        #region Member Variables

  

        readonly ApplicationSettingsSection _section = (ApplicationSettingsSection)ConfigurationManager.GetSection("ApplicationSettings");

  

        #endregion //Member Variables

  

...

  

#region SetMapTileLayers

private void SetMapTileLayers(string thematicstr)

{

    foreach (UIElement item in MainMap.Children)

    {

        if (item is MapTileLayer)

        {

            MapTileLayer mtile = item as MapTileLayer;

            string layer = mtile.Name;

            foreach (LocationRectTileSource tilesource in mtile.TileSources)

            {

                tilesource.UriFormat = _section.AppSettings["remoteServer"].Value + layer.Replace("layer", "").ToLower() + "/{quadkey}/" + thematicstr;

            }

        }

    }

}

#endregion //SetMapTileLayers

  

}

Run the Application

Start the application

Check “Countries” CheckBox to receive tiles from SQL Server 2008 spatial data.

Check “Thematic Tiles” to create a thematic map (by default thematic map tiles color is by area.

Select Radio button “Color by Population” to create a thematic map by population.

Navigate changing the zoom (drag map for pan, double click for zoom in , click “default zoom “ button to go back to the default zoom level.

Enjoy! You have now a real thematic map on your Windows Phone 7 .

Source code of the demo application you could download here:(Please visit the site to view this media)

Sample database you download here:(Please visit the site to view this media)

Migrating Spatial Data from SQL Server 2008 to SQL Azure

[Infragistics] Mihail Mateev — Tue, 21 Sep 2010 10:49:00 GMT

Introduction

SQL Azure now supports Spatial Data. Unfortunately not all tools offer migration of spatial data..

Microsoft SQL Management Studio for SQL Server 2008 R2 is released when SQL Azure didn’t support spatial data and now they are no updated to
support this feature.

One possibility is to use SQL Azure Migration Wizard: http://sqlazuremw.codeplex.com/

The actual version is SQL Azure Migration Wizard v3.3.7.

SQL Azure Migration Wizard offers a simple way to import Sql Server data, including a spatial data (from geometry or geography type).
More detailed information how to publish a Windows Azure you could find in the article:
“How to publish your Windows Azure application right from Visual Studio 2010”

This post explains mainly how to migrate spatial data and change configuration changes to be possible
to use a spatial data in SQL Azure from Windows Azure Application

Sample Application

Demo application is a Silverlight application with Infragistics XamMap control, that uses spatial data from SQL Azure.

The sample application is based on application from article “Using Infragistics XamMap Silverlight/WPF control with SQL Server Spatial”

Requirements to build a sample application:

Visual Studio 2010
SQL Server 2008 R2 Express or higher license.
NetAdvantage for Silverlight Data Visualization 2010 vol.2
http://www.infragistics.com/dotnet/netadvantage/silverlight/data-visualization.aspx#Downloads
SQL Azure Migration Wizard v3.3.7.
The most recent version of Windows Azure Tools for Visual Studio
Windows Azure account

Steps to create the sample application

Create a new SQL Azure database
Migrate a sample database – SqlSpatialDemo from Local SQL Server to SQL Azure
Create a new Windows Azure Storage Account and a Hosted Service
Add a Web Role project in Solution
Edit settings in Web.config and ServiceReferences.ClientConfig
Publish the Windows Azure Cloud Service:
Run the demo application

Create a new SQL Azure database

Select SQL Azure->Database to see a list with existing databases

Select “Create Database” and choose the name and size of
the new database.

A new database is added in the list with existing

Migrate a sample database – SqlSpatialDemo from Local SQL Server to SQL Azure

Edit configuration of the SQL Migration Wizard in SQLAzureMW.exe.config

<?xml version="1.0" encoding="utf-8"?>

<configuration>

    <appSettings>

        <add key="SourceConnectNTAuth" value="true"/>

        <add key="SourceServerName" value=".\SQLEXPRESS" />

        <add key="SourceUserName" value="" />

        <add key="SourcePassword" value="" />

  

<add key="TargetConnectNTAuth" value="false"/>

<add key="TargetServerName" value="tcp:MyDatabaseServerName.database.windows.net"/>

<add key="TargetUserName" value="DatabaseUser@MyDatabaseServerName"/>            <!-- NOTE BCP requires that you have the SQL Azure server name the end of the user name ie. UserSA@jy8kadhrma -->

<add key="TargetPassword" value="MyPassword"/> 

  

 <add key="BCPFileDir" value="c:\SQLAzureMW\BCPData" />         <!-- Input / Output file location for BCP table data.  If blank, then will use temp directory -->

 <add key="DelOldBCPFiles" value="true" />                      <!-- Deletes old BCP files if exists, otherwise, it will add a unique numeric ext -->

 <add key="BCPFileExt" value="dat"/>                            <!-- BCP output file extension -->

 <add key="DeleteBCPOutputFiles" value="false"/>                <!-- If true, SQLAzureMW will delete the temporary BCP output files after successfully uploading to target server --> 

  

….

  

    </appSettings>

</configuration>

To work migration wizard properly need to set TargetUserName with user@ServerName format:
<add key="TargetUserName" value="DatabaseUser@MyDatabaseServerName"/>

Start SQL Migration Wizard and select “Analyze an Migrate option

Log to the local SQL server

Select the database that want to migrate

For “Choose Objects” select “Script all database objects”.

In “Advanced Settings” ensure that for “Script Table / Data” is selected option: “Table Schema with Data”.

Connect to SQL Azure server.

Select the created database where plan to migrate the local database.

Select “Next” and wait until migration is complete.

Open Microsoft SQL Management Studio, connect to SQL Azure server, select
migrated database and create a new query.

Write select * from world

In the “Spatial results” tab there is a map of the world.

Create a new Windows Azure Storage Account and a Hosted Service.

Select “New Service”

Create a storage account

Create a Hosted Service in the same way.

Add a Web Role project in Solution

Add a new Windows Azure Cloud Service project.

Skip creating of new Web Role in this project.

Add a Web Role project in Solution.

If you want to add new Web Role project there are additional setting that must be done.
Steps are describe in the article: Windows Azure Web Role Deployment Checklist

In this sample there is no need to do that.

Edit settings in Web.config and ServiceReferences.ClientConfig

Open Web.config and change the connection string:

<appSettings>

  <add key="token" value="[YourToken here]"/>

  <!--<add key="connectionString" value="Data Source=.\SQLEXPRESS;Initial Catalog=SqlSpatialDemo;Integrated Security=True"/>-->

  

</appSettings>

  <connectionStrings>

    <add name="SqlSpatial"

          connectionString="Server=tcp:[MyDatabaseServerName].database.windows.net;Database=[Database Name];User ID=[DatabaseUser]@[MyDatabaseServerName];Password=[MyPassword];Trusted_Connection=False;Encrypt=True;Min pool size = 5; Max pool size = 100"

          providerName="System.Data.SqlClient"

         />   

  </connectionStrings>

In the Silverlight application modify the ServiceReferences.ClientConfig file:

Change the endpoint address with an expected one when application is published:
for example: http://MyAzureApplication.cloudapp.net/SqlDbService.svc

where MyAzureApplication.cloudapp.net is the endpoint address of your application.

<client>

    <!--<endpoint address="http://localhost:4159/SqlDbService.svc" binding="customBinding"

        bindingConfiguration="CustomBinding_SqlDbService" contract="SqlDbServiceReference.SqlDbService"

        name="CustomBinding_SqlDbService" />-->

  <endpoint address="http://MyAzureApplication.cloudapp.net/SqlDbService.svc" binding="customBinding"

                            bindingConfiguration="CustomBinding_SqlDbService" contract="SqlDbServiceReference.SqlDbService"

                            name="CustomBinding_SqlDbService" />                    

...

</client>

Publish the Windows Azure Cloud Service:

Add a reference to Microsoft.SqlServer.Types library from SQL Server 2008 R2 SDK.

Change in properties option “Copy Local” to true.

We need it because Windows Azure doesn’t know about Spatial types
(geometry and geography).

Create a certificate for authentication: for more details you could look at the article: “How to publish your Windows Azure application right from Visual Studio 2010”

Publish the Windows Azure Cloud Service

Run the published application and enjoy!

Source code of the demo application you could find here:(Please visit the site to view this media)