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

5 posts, 1 answers
  1. Dan
    Dan avatar
    2 posts
    Member since:
    Nov 2010

    Posted 29 Nov 2010 Link to this post

    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:
    Snippet
         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
  2. Answer
    Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 30 Nov 2010 Link to this post

    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
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  3. DevCraft banner
  4. Dan
    Dan avatar
    2 posts
    Member since:
    Nov 2010

    Posted 30 Nov 2010 Link to this post

    Thanks for the quick response.

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

    Cheers,
    Dan
  5. Craig
    Craig avatar
    1 posts
    Member since:
    Nov 2010

    Posted 16 Feb 2011 Link to this post

    Any updates on this?  Really looking forward to spatial query capability...
  6. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 21 Feb 2011 Link to this post

    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
Back to Top
DevCraft banner