WCF (REST) Service with Spatial DB Types?

[gigemboy]

I am trying to create a REST endpoint through WCF Data Services to expose some spatial data in a SQL Server 2008 database, but the way I am doing it doesn't support spatial data types (geography/geometry).

In this intro video it shows how to use the ADO.NET entity data model, but that data model doesn't support spatial types, and shows errors when I select the spatial table.

Does anyone know of something I can do to resolve this, or can point me in the right place in order to find more info? I just want a REST endpoint that exposes a set of points from my database.

[gep13]

Hello,

I think this question is better answered in the WCF Forum. I am going to move it over there.

Thanks

Gary

[gigemboy]

I found this link that has a sort of 'hack' by creating a view and casting the field as binary. You can then get it back on the client end by converting it back. In theory, it should work.