public void TestSTAsKML()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var g1 = db.Select(() => GeometryInput.STGeomFromText("POLYGON((0 0,0 1,1 1,1 0,0 0))", 4326));
var kml1 = db.Select(() => GeometryOutput.STAsKML(g1));
Assert.AreEqual("<Polygon><outerBoundaryIs><LinearRing><coordinates>0,0 0,1 1,1 1,0 0,0</coordinates></LinearRing></outerBoundaryIs></Polygon>", kml1);
Assert.IsNull(db.Select(() => GeometryOutput.STAsKML(null)));
// geography
db.TestGeographies
.Value(g => g.Id, 1)
.Value(g => g.Geography, () => GeometryInput.STGeographyFromText("POINT(30 60)"))
.Insert();
var kml2 = db.TestGeographies
.Where(g => g.Id == 1)
.Select(g => g.Geography.STAsKML())
.Single();
Assert.AreEqual(
"<Point><coordinates>30,60</coordinates></Point>",
kml2);
}
}
public void TestSTAsKML()
{
using (var db = new PostGisTestDataConnection(TestDatabaseConnectionString))
{
var g1 = db.Select(() => GeometryInput.STGeomFromText("POLYGON((0 0,0 1,1 1,1 0,0 0))", 4326));
var kml1 = db.Select(() => GeometryOutput.STAsKML(g1));
Assert.AreEqual("<Polygon><outerBoundaryIs><LinearRing><coordinates>0,0 0,1 1,1 1,0 0,0</coordinates></LinearRing></outerBoundaryIs></Polygon>", kml1);
Assert.IsNull(db.Select(() => GeometryOutput.STAsKML(null)));
}
}
