I am working on a application where I need to get nearby location,
my web service will receive 2 parameters (decimal longitude, decimal latitude )
I have a table where the locations are saved in database with longitude and latitude fields,
I want to retrieve the nearest locations.
Can anyone help?
Here is my code:
var locations = from l in locations
select l
Here are further details about this :
i have a 2 fields (decimal(18, 2) null) 1 latitude, 2 longitude inside a database table,
and i have a method
public List<Locations> GetLocation(decimal? Long, decimal? lat)
{
var Loc = from l in Locations
//// now here is how to get nearest location ? how to query?
//// i have also tried Math.Abs(l.Lat - lat) its giving error about nullable decimal always hence i have seted decimal to nullable or converted to nullable
//// also i have tried where (l.lat - Lat) * (l.lon - Long) this is also giving error about can not convert decimal to bool
return Loc.ToList();
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…