Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 05, 2011 05:17 PM by sjnaughton
Member
167 Points
110 Posts
Nov 05, 2011 04:13 PM|LINK
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?
All-Star
37360 Points
6840 Posts
Nov 05, 2011 04:25 PM|LINK
Robwarning 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
27330 Points
5459 Posts
MVP
Nov 05, 2011 05:10 PM|LINK
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
Nov 05, 2011 05:14 PM|LINK
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
Nov 05, 2011 05:17 PM|LINK
That is what I have done, I just check EF 4 does not support geography or geometry yet.
Robwarning
Member
167 Points
110 Posts
using sql Geography data type
Nov 05, 2011 04:13 PM|LINK
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?
Rob Warning
Rajneesh Ver...
All-Star
37360 Points
6840 Posts
Re: using sql Geography data type
Nov 05, 2011 04:25 PM|LINK
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
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: using sql Geography data type
Nov 05, 2011 05:10 PM|LINK
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
Always seeking an elegant solution.
Robwarning
Member
167 Points
110 Posts
Re: using sql Geography data type
Nov 05, 2011 05:14 PM|LINK
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
Rob Warning
sjnaughton
All-Star
27330 Points
5459 Posts
MVP
Re: using sql Geography data type
Nov 05, 2011 05:17 PM|LINK
That is what I have done, I just check EF 4 does not support geography or geometry yet.
Always seeking an elegant solution.