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