I have a table in SQL Server that has geography datatype column in it. I want to query this table to find rows that fall near (within a range) of another given geography point. Does anyone have any ideas as to the best way to do this?
I have 2 options of where to do this type of query. I can write it on the sql server as a stored proc or I can do it in c# code as I am using the Entity Framework for data access.
I would have a query that has a range (eg 100m) and a geography point passed in to it.
The pseudo code would be something like this…
where rows.geo within range of given geography point
I’m having a bit of trouble finding examples of geography queries in SQL Server on the web.
Any help would be appreciated.