public static List<Location> GetNearest(float lat, float lon) { try { EcommercePlatformDataContext db = new EcommercePlatformDataContext(); string query = String.Format(@"SELECT * FROM Locations ORDER BY ( 3959 * acos( cos( radians({0}) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians({1}) ) + sin( radians({0}) ) * sin( radians( latitude ) ) ) )", lat, lon); List<Location> loc = db.ExecuteQuery<Location>(query).ToList<Location>(); return loc; } catch (Exception e) { throw e; } }