using System;

using System.Data;

using Microsoft.SqlServer.Types;

using Newtonsoft.Json;

using Newtonsoft.Json.Serialization;

using System.Xml;

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello SqlGeography");

        var dt= GetGeoTable();

        SerializeToJson(dt);

    }

    //create datatable with SqlGeography datatype

    static DataTable GetGeoTable()

        {

            DataTable dataTable = new DataTable("table");

            dataTable.Columns.Add("f1", typeof(SqlGeography));

            dataTable.Columns.Add("id", typeof(int));

​

            DataRow newRow = dataTable.NewRow();           

            newRow["f1"] = SqlGeography.Point(20, 10, 4326); //lat long

            newRow["id"] = 1;

            dataTable.Rows.Add(newRow);

​

            newRow = dataTable.NewRow();

            newRow["f1"] = SqlGeography.Point(30, 15, 4326);

            newRow["id"] = 2;

            dataTable.Rows.Add(newRow);

​

            foreach (DataRow row in dataTable.Rows)

            {

                string ID = row["id"].ToString();

                string f1 = row["f1"].ToString();

                Console.WriteLine("{0} {1}", ID, f1);

            }            

            return dataTable;

        }

    //Serialize datatable to Json

     static string SerializeToJson(DataTable dt)

        {   

​

            ITraceWriter traceWriter = new MemoryTraceWriter();           

            try

            {

                var options = new JsonSerializerSettings

                {   

                    Formatting = Newtonsoft.Json.Formatting.Indented,

                      TraceWriter = traceWriter,                   

                };

                var json = JsonConvert.SerializeObject(dt, options);

                Console.WriteLine(json);

                return json;

            }

            catch (Exception ex)

            {

                Console.WriteLine(traceWriter);

                Console.WriteLine(ex);

            }           

            return "";           

        }

​

}