Accepted answer

while not a sql answer, i always recommend this explanation for how to calculate distances between lat-lng -

for sql server, assuming you are using sql server 2008, then you can use the native sql geography types. however, sadly i don't think these map well to linq-2-sql so you will probably need to wrap them within stored procedures.


Related Query