public void TestSTTranslatedXYZ()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "POINT(0 0 0)";
db.TestGeometries.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromText(Wkt))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(5, 12, 3))
.Select(g => GeometryOutput.STAsEWKT(g))
.Single();
Assert.AreEqual("POINT(5 12 3)", result);
var result2 = db
.Select(() => AffineTransformations.STTranslate(Wkt, 5, 12, 3).STAsEWKT());
Assert.AreEqual("POINT(5 12 3)", result2);
}
}
public void TestSTTranslatedXY()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "POINT(-71.01 42.37)";
db.TestGeometries
.Value(g => g.Id, 1)
.Value(g => g.Geometry, () => GeometryInput.STGeomFromText(Wkt, 4326))
.Insert();
var result = db.TestGeometries
.Where(g => g.Id == 1)
.Select(g => g.Geometry.STTranslate(1, 0).STAsText())
.Single();
Assert.AreEqual("POINT(-70.01 42.37)", result);
var result2 = db
.Select(() => AffineTransformations.STTranslate(Wkt, 1, 0).STAsText());
Assert.AreEqual("POINT(-70.01 42.37)", result2);
}
}