public void FeatureCollectionDbQueryTest() { string conn = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Projects\GeospatialServices\TestGeospatialServices\Input\Runtime\TestGeospatialServicesDatabase.mdf;Integrated Security=True;User Instance=True"; GeospatialServices.Ogc.Wmc.Layer data = new GeospatialServices.Ogc.Wmc.Layer("world_admin", conn, "world_admin", "shape", "fid"); GeospatialServices.Runtime.FeatureDataSet fds = new GeospatialServices.Runtime.FeatureDataSet(); //UK POLYGON ((-7.5191669464111328 49.955268859863281, 1.7424999475479126 49.955268859863281, 1.7424999475479126 60.631099700927734, -7.5191669464111328 60.631099700927734, -7.5191669464111328 49.955268859863281)) //US POLYGON ((-178.21420288085938 18.924720764160156, 179.40299987792969 18.924720764160156, 179.40299987792969 71.406646728515625, -178.21420288085938 71.406646728515625, -178.21420288085938 18.924720764160156)) string queryGeometryString = "POLYGON ((-176.84950256347656 -50.854450225830078, 178.5596923828125 -50.854450225830078, 178.5596923828125 -34.398349761962891, -176.84950256347656 -34.398349761962891, -176.84950256347656 -50.854450225830078))"; SqlGeometry queryGeometry = SqlGeometry.STGeomFromText(new System.Data.SqlTypes.SqlChars(new System.Data.SqlTypes.SqlString(queryGeometryString)), 4326); data.ExecuteSpatialQuery(queryGeometry, fds); Assert.IsTrue(fds.Tables[0].Count == 7); }
public void FeatureCollectionActionsTest() { string conn = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Projects\GeospatialServices\TestGeospatialServices\Input\Runtime\TestGeospatialServicesDatabase.mdf;Integrated Security=True;User Instance=True"; GeospatialServices.Ogc.Wmc.Layer data = new GeospatialServices.Ogc.Wmc.Layer("world_admin", conn, "world_admin", "shape", "fid"); GeospatialServices.Runtime.FeatureDataSet fds = new GeospatialServices.Runtime.FeatureDataSet(); string queryGeometryString = "POLYGON ((-176.84950256347656 -50.854450225830078, 178.5596923828125 -50.854450225830078, 178.5596923828125 -34.398349761962891, -176.84950256347656 -34.398349761962891, -176.84950256347656 -50.854450225830078))"; SqlGeometry queryGeometry = SqlGeometry.STGeomFromText(new System.Data.SqlTypes.SqlChars(new System.Data.SqlTypes.SqlString(queryGeometryString)), 4326); data.ExecuteSpatialQuery(queryGeometry, fds); Assert.IsTrue(fds.Tables[0].Count == 7); fds.Tables[0].RemoveRow(fds.Tables[0][0]); Assert.IsTrue(fds.Tables[0].Count == 6); fds.Tables[0][0].Geometry = queryGeometry; Assert.IsTrue(fds.Tables[0][0].IsFeatureGeometryNull() == false); fds.Tables[0][0].SetFeatureGeometryNull(); Assert.IsTrue(fds.Tables[0][0].IsFeatureGeometryNull() == true); fds.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; string schema = fds.GetXmlSchema(); string xml = fds.GetXml(); }