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:
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
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.