using sql Geography data type

Question

User-28820329 posted

Hi, I am setting up a database witch should contain geographic data (lat, long) information to plot  locations in bing maps or Google maps.

I thougt to use the sql geography data type for this. The administration for the database I like to do with ASP dynamic data.

The problem is that there are no Fieldtemplates for this geographic data type. Is there sombody who knows how to solve this?

Answer 1

User1992938117 posted

The problem is that there are no Fieldtemplates for this geographic data type. Is there sombody who knows how to solve this?

Are you looking for:

http://blog.sqlauthority.com/2011/08/18/sql-server-tips-from-the-sql-joes-2-pros-development-series-geography-data-type-calculating-distance-between-two-points-on-the-earth-day-18-of-35/

http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/

http://msdn.microsoft.com/en-us/library/bb895266.aspx

Answer 2

User-330204900 posted

Hi Rob, what do you want the field templates to be able to do? P.S. I'm not sure the EF support the geography types as yet

Answer 3

User-28820329 posted

mmm..

I see, this is not as simple as I tought. Maybe I should simply use two float values for lat and long.

as I only need to plot locations on a map this should be enough.

thanks for your answer

Answer 4

User-330204900 posted

That is what I have done, I just check EF 4 does not support geography or geometry yet.