Is SQL Spatial supported in Compact Framework 3.5 and Sql CE 3.5 SP1?

Question

Is SQL Spatial supported in Compact Framework 3.5  and Sql CE 3.5 SP1?

Answer 1

AFAIK, the answer is no, and no. (Although spatial is supported in SQL Express).

If you're looking for methods to architect spatially-enabled apps on mobile devices, then you might find the following blog post helpful:
http://blogs.msdn.com/davidlean/archive/2008/11/03/sql-2008-ways-to-architect-spatial-apps.aspx

---

Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290

Answer 2

I've already posted the answer to this question in your other threads but the answer to the question is "no." The mentions of the geography types that you saw in the SQL Server Compact 3.5 documentation were in reference to SQL Server 2008. When data of that type is replicated to an SQL Server Compact 3.5 database it is mapped to the image data type. More information on that can be found here:

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

---

Joel Ivory Johnson

http://www.j2i.net

It takes all the running you can do to stay in one place.If you want to get somewhere else,you must try to run at least twice as fast as that.

Answer 3

Hi Tim,

As the other posters have said, there's no official support for SQL Spatial in CE. But a company called Maptel has an implementation using the binary format (that was published a while ago), available as a library. The URL is http://www.maptel.com.au/maptel/index.html. I don't see it listed as an official product, but I'd write to the "info" email address if you're interested in more info.

Hope this helps,
Bob Beauchemin
SQLskills

Answer 4

Thanks guys for the clarification on this. Are there any plans to introduce this functionality for Compact Framework in future? We are working on windows mobile applications and many clients have expressed interest in being able to create a geometry using GPS coordinates and storing the same in sql 08 using sync services. At this time we have been using ESRI's ArcGIS to achieve this but would definitely prefer Microsoft's robust technology over these proprietary softwares.

Thanks

Answer 5

 Are there any plans to introduce this functionality for Compact Framework in future?

As of yet there's been no announcements on forthcoming updates to the .Net Compact Framework.  Even looking at Visual Studio 2010 Beta support for the compact framework is not yet present, so there is no information from which one can infer.

---

Joel Ivory Johnson

http://www.j2i.net

It takes all the running you can do to stay in one place.If you want to get somewhere else,you must try to run at least twice as fast as that.