public IEnumerable<DataSetAdventureWorks.SalesOrderHeaderRow> Find(IOrderFilter filter)
{
using (var adapter = new SqlDataAdapter(SelectOrderCommandText, Connection as SqlConnection))
{
adapter.SelectCommand.CommandText = filter.BuildWhereClause(SelectOrderCommandText);
Orders.Clear();
adapter.Fill(Orders);
}
return Orders;
}
