Search for existing suggestions

Support for spatial types and spatial query

Support for spatial types and spatial query

182 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike Flasko shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    12 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • CapRus commented  ·   ·  Flag as inappropriate

        New Features of EF should handle all the new features of Sql server 2008 R2 , mostly the Spatial types like Geography and Filestream Varbinary(max) tool.If its integrated with a File Table i think then web will go beyond

      • Dipesh Avlani commented  ·   ·  Flag as inappropriate

        I have had to place workarounds to achieve this. It is very painful to work around problems caused due to certain technologies supporting spatial data types and others not. Including these types in EF would make life a lot easier.

      • Christophe Vialatte commented  ·   ·  Flag as inappropriate

        Hi,

        We are not able to use the spatial data type in our app without doing a lot of tricks. This would be very useful if implemented.

        Regards

      • Romiko commented  ·   ·  Flag as inappropriate

        Lets get this done asap guys! A work around requires triggers and lat long switching etc!

        CREATE FUNCTION [dbo].[fn_GenerateGeoGeography]
        (
        @GeoLocation varchar(max)
        )
        RETURNS Geography
        AS
        BEGIN
        -- Declare the return variable here
        DECLARE @Point GEOGRAPHY


        --We need to switch Latitude and Longitude around as the Geography Data Type has {Long Lat}
        DECLARE @TextGeolocation VARCHAR(max)

        SELECT @TextGeolocation =
        'Point(' +
        SUBSTRING(@GeoLocation, PATINDEX ('% %',@GeoLocation), PATINDEX ('%)%',@GeoLocation) - PATINDEX ('% %',@GeoLocation) )
        + ' ' +
        SUBSTRING(@GeoLocation, PATINDEX ('%(%',@GeoLocation) + 1, PATINDEX ('%,%',@GeoLocation) - PATINDEX ('%(%',@GeoLocation) - 1 )
        + ')'


        SELECT @Point = (
        geography::STGeomFromText(@TextGeolocation, 4326)

        )
        RETURN @Point
        END

      • Mike Gates commented  ·   ·  Flag as inappropriate

        This would be very useful if implemented. Entity Framework is in version 4 now, it should be able to support all the native types.

      • Johan Bisschoff commented  ·   ·  Flag as inappropriate

        This is a crucial feature for our company. We found a way around it for now, but this nearly made us go for a different GIS solution.

      • Cássio Rogério Eskelsen commented  ·   ·  Flag as inappropriate

        It is unfair to put this item in voting because he serves a small audience specific, but 100% of this specific audience needs this functionality

      • Cássio Rogério Eskelsen commented  ·   ·  Flag as inappropriate

        It is unfair to put this item in voting because he serves a small audience specific, but 100% of this specific audience needs this functionality

      • kamran commented  ·   ·  Flag as inappropriate

        This is a must, since Microsoft SQL Server supports them, Microsofts own ORM should also support them.

      Feedback and Knowledge Base