public void CanGetRowsNotInUUIDList() { IFeatureWorkspace ws = OpenTestWorkspace(); ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE"); var nRows = 0; IQueryFilter filter = new QueryFilterClass(); foreach ( // ReSharper disable once UnusedVariable IRow row in GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "UUID", new[] { "{8C5517C9-B19F-4CC1-A6A1-D3DD317BCDD1}" })) { nRows++; } filter.WhereClause = "UUID not in ('{8C5517C9-B19F-4CC1-A6A1-D3DD317BCDD1}')"; int n = tbl.RowCount(filter); Assert.AreEqual(n, nRows, ""); }
public void CanGetRowsNotInStringList() { IFeatureWorkspace ws = OpenTestWorkspace(); ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE"); var nRows = 0; IQueryFilter filter = new QueryFilterClass(); foreach ( // ReSharper disable once UnusedVariable IRow row in GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "OPERATEUR", new[] { "STR_Imp" })) { nRows++; } filter.WhereClause = "OPERATEUR not in ('STR_Imp')"; int n = tbl.RowCount(filter); Assert.AreEqual(n, nRows, ""); }
public void CanGetRowsNotInIntList() { IFeatureWorkspace ws = OpenTestWorkspace(); ITable tbl = ws.OpenTable("TOPGIS_TLM.TLM_STRASSE"); var nRows = 0; IQueryFilter filter = new QueryFilterClass(); foreach ( // ReSharper disable once UnusedVariable IRow row in GdbQueryUtils.GetRowsNotInList(tbl, filter, true, "OBJEKTART", new object[] { 1, 2, 3 })) { nRows++; } filter.WhereClause = "OBJEKTART not in (1, 2, 3)"; int n = tbl.RowCount(filter); Assert.AreEqual(n, nRows, ""); }