How To used stored location in database with location calculate distance method

Question

I am working on MAUI to calculate distance between two locations. I have stored the first et of location in an sqlits database. Using Location calculate distance method, I got error Severity Code Description Project Path File Line Suppression State

Error	CS1503	Argument 1: cannot convert from 'double' to 'Microsoft.Maui.Devices.Sensors.Location'

the program

return await conn.Table().Where(s => s.location == Location.CalculateDistance(abuja,s.location < 3.0, DistanceUnits.Kilometers)).ToListAsync();

Accepted Answer

you have a couple issues.

a Location can not be stored in a sqlite database, typically you would store the lat & long, as two double columns.

second the where expression makes no sense. s.location < 3.0 is a bool, but the Location.CalculateDistance() has no overload with a bool.

third the Location.CalculateDistance can not be converted to sql, so you would be need to read the table into a memory collection first:

return (await conn.Table().ToListAsync())
   .Where(s => 
       Location.CalculateDistance
       (
          s.loctionLat, 
          s.locationLong,
          abuja,
          DistanceUnits.Kilometers
       ) < 3.0
   ),
   .ToListAsync();

Share via

How To used stored location in database with location calculate distance method

0 additional answers