public static IEnumerable <Row> Like(this RowCollection rowCollection, string column, string pattern)
{
return(rowCollection.Where(row =>
row.Cells[column] != null && row.Cells[column].Value != null &&
row.Cells[column].Value.Type == typeof(string) &&
((string)row.Cells[column].Value).Like(pattern)));
}
public static IEnumerable <Row> Where(this RowCollection rowCollection, params Condition[] conditions)
{
return(rowCollection.Where((IEnumerable <Condition>)conditions));
}
public static IEnumerable <Row> Where(this RowCollection rowCollection, IEnumerable <Condition> conditions)
{
return(rowCollection.Where(row => CheckRowForConditions(row, conditions)).ToList());
}
public static IEnumerable <Row> Where(this RowCollection rowCollection, string column, Comparison comparison, DbValue value)
{
return(rowCollection.Where(new Condition(column, comparison, value)));
}
