When I try to get the distance between two points:
- POINT (-0.4246 38.4099)
- POINT (-0.5199 38.3961)
The result should be '8464' meters. I get this result when using the DbGeography.Distance function in our code targeting our SqlServer database. Also obtained this value when I was developing using Oracle ODP.Net Provider. But now that I've switched to dotConnect, I'm getting '0,0962939769663716'.
Test Code:
Code: Select all
Console.WriteLine("Distance between {0} and {1}: {2}", start.AsText(), end.AsText(), start.Distance(end));
Distance between POINT (-0.4246 38.4099) and POINT (-0.5199 38.3961): 0,0962939769663716
When I execute this sentence directly in Oracle Developer I also get correct results:
Code: Select all
select sdo_geom.sdo_distance(
sdo_geometry(2001, 4326, sdo_point_type(-0.4246, 38.4099, null), null, null),
sdo_geometry(2001, 4326, sdo_point_type(-0.5199, 38.3961, null), null, null),
0.005)
from dual;
Code: Select all
<SpatialOptions SpatialServiceType="NetTopologySuite" AlwaysUseGeographyDefaultSrid="true" GeographyDefaultSrid="4326" />
Am I missing something or doing something wrong?