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))); } }