Assume I already have a database with contractor name, address, and geocode (40.714224,-73.961452) of each address.
and it has around 100 records only.
Address, City, State, Zip, Geocode1, GeoCode2
And now I want to create asp.net / c# / mvc app that allow end user to enter zip code, distance mile like 1 to 5
and allow the end user to search all of the contractors and sorted by shortest distance in mileage.
Can you show me how the query should look like? Thanks,