public void TestSTAsHEXEWKB()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var g1 = db.Select(() => GeometryInput.STGeometryFromText("POLYGON((0 0,0 1,1 1,1 0,0 0))", 4326));
var hexewkb = db.Select(() => GeometryOutput.STAsHEXEWKB(g1));
Assert.AreEqual("0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000", hexewkb);
Assert.IsNull(db.Select(() => GeometryOutput.STAsHEXEWKB(null)));
}
}
public void TestSTAsHEXEWKB()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
const string Wkt = "POLYGON((0 0,0 1,1 1,1 0,0 0))";
const string HexEwkb = "0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000";
var g1 = db.Select(() => GeometryInput.STGeometryFromText(Wkt, 4326));
var hexewkb = db.Select(() => GeometryOutput.STAsHEXEWKB(g1));
Assert.AreEqual(HexEwkb, hexewkb);
Assert.AreEqual(HexEwkb, db.Select(() => GeometryOutput.STAsHEXEWKB("SRID=4326;" + Wkt)));
Assert.AreEqual(
"000000000140000000000000004010000000000000",
db.Select(() => GeometryOutput.STAsHEXEWKB(GeometryConstructors.STMakePoint(2, 4), EndiannessEncoding.BigEndian)));
Assert.AreEqual(
"000000000140000000000000004010000000000000",
db.Select(() => GeometryOutput.STAsHEXEWKB("POINT(2.0 4.0)", EndiannessEncoding.BigEndian)));
Assert.IsNull(db.Select(() => GeometryOutput.STAsHEXEWKB((NTSG)null)));
}
}
