[GIS] How to load spatial data into ArcGIS Javascript API application from SQL Server 2008

arcgis-javascript-apiarcgis-serversql server

I have geometry data in SQL Server 2008 R2. How do I load that spatial data using the ArcGIS Javascript API?

Best Answer

Write a WCF service that returns a JSONP response. WCF service should return a data in following format:

[
{
    "feature": {
        "attributes": {
            "objectid": 1,
            "fdate": 932428800000,
            "resolution": 3,
            "gnis_id": null,
            "gnis_name": null,
            "lengthkm": 0.024,
            "reachcode": "11070101001016",
            "flowdir": 1,
            "wbareacomid": null,
            "ftype": 558,
            "fcode": 55800,
            "enabled": 1
        },
        "geometry": {
            "paths": [
                [
                    [
                        -95.9899452281111,
                        38.1345878074741
                    ],
                    [
                        -95.9898896947778,
                        38.1344644074744
                    ],
                    [
                        -95.9899164947778,
                        38.1343866074744
                    ]
                ]
            ]
        }
    }
}
]
Related Question