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;
}
}