Search for existing suggestions

Support for spatial types and spatial query

Support for spatial types and spatial query

182 votes
Sign in
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
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