public void TestST3DLongestLine()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var pt = db.Select(() => GeometryInput.STPointFromText("POINT(100 100 30)"));
var line = db.Select(() => GeometryInput.STLineFromText("LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 1000)"));
var lline1 = db.Select(() => MeasurementFunctions.ST3DLongestLine(line, pt).STAsEWKT());
Assert.AreEqual("LINESTRING(50 75 1000,100 100 30)", lline1);
}
}
public void TestST3DLongestLine()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string PointWkt = "POINT(100 100 30)";
const string LineWkt = "LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 1000)";
var point = db.Select(() => GeometryInput.STPointFromText(PointWkt));
var line = db.Select(() => GeometryInput.STLineFromText(LineWkt));
var lline1 = db.Select(() => MeasurementFunctions.ST3DLongestLine(line, point).STAsEWKT());
Assert.AreEqual("LINESTRING(50 75 1000,100 100 30)", lline1);
Assert.AreEqual(
"LINESTRING(50 75 1000,100 100 30)",
db.Select(() => MeasurementFunctions.ST3DLongestLine(LineWkt, PointWkt).STAsEWKT()));
Assert.IsNull(db.Select(() => MeasurementFunctions.ST3DLongestLine((NTSG)null, (NTSG)null)));
}
}
