Execution of 'Microsoft.SqlServer.Types.SqlGeography:STIntersects(SqlGeography)' on the database server side currently not implemented.

[Dan]

hello,

I am interested in using OpenAccess's new SQL Spatial type support, however, when testing this out with a query using the STIntersects method i get the following exception:

Execution of 'Microsoft.SqlServer.Types.SqlGeography:STIntersects(SqlGeography)' on the database server side currently not implemented.

does this mean that the new Spatial type support does not completely handle all the associated SQL Spatial methods?

my query is as follows:

     SampleGeographyDataEntityDiagrams dc = new SampleGeographyDataEntityDiagrams();
     SqlChars polygon = new SqlChars(new SqlString("POLYGON((" + userInputPoints + "))"));  // selection geometry
     var mapDataQuery = from c in dc.Countries
                        where c.GeographyData.STIntersects(SqlGeography.STGeomFromText(polygon, srid)).IsTrue
                        select c;

Note: at the moment I am just connecting to a sample DB running on the SQLExpress instance installed with Visual Studio 2010. 

Please let me know if this should work and/or what limitations are associated with the new SQL Spatial type support.
Thanks,
Dan

[Thomas]

Hello Dan,

 at the moment, your observation is right: Linq support for methods on such types is not implemented yet. However, we are planning to include that in the next release (Q1 2011). As a workaround, you might want to consider the usage of direct SQL queries, which can include such SQL server methods.

Hope this helps,
Thomas
the Telerik team

[Dan]

Thanks for the quick response.

Guess I will stick with SQL queries for now and wait for the update next year.

Cheers,
Dan

[Craig]

Any updates on this?  Really looking forward to spatial query capability...

[Damyan Bogoev]

Hi Craig,

The Linq support for user defined methods is on our to-do list. We will try to implement it for the next Q1 release.
I am sorry for the inconvenience caused.

Best wishes,
Damyan Bogoev
the Telerik team