public void reverse_is_null()
{
var filter = new IsNullFilter(Substitute.For <IField>());
filter.Reverse().ShouldBeOfType <IsNotNullFilter>()
.Field.ShouldBe(filter.Field);
}
public void GetRowsWithNullFirstName()
{
IRowFilter filter = new IsNullFilter(this.table.GetColumnPosition("FirstName"));
RowList rows = this.table.ApplyFilter(filter);
Assert.IsNotNull(rows);
Assert.AreEqual(0, rows.Count);
}
public void GetRowsWithNullAddress()
{
IRowFilter filter = new IsNullFilter(this.table.GetColumnPosition("Address"));
RowList rows = this.table.ApplyFilter(filter);
Assert.IsNotNull(rows);
Assert.AreEqual(this.table.RowCount / 2, rows.Count);
foreach (Row row in rows)
{
Assert.IsNull(row["Address"]);
}
}