| public FillByWhereClause ( Category dataTable, string whereClause, System parameters ) : int | ||
| dataTable | Category | |
| whereClause | string | |
| parameters | System | |
| return | int | |
public override List<Identity> GetAll(NorthwindConfig config, string whereExpression, OleDbParameter[] oleDbParameters)
{
#region Declarations
List<Identity> result = new List<Identity>();
int recordCount = 0;
Category dataset = new Category();
#endregion
// get the first 11 rows of the changelog
using (OleDbConnection connection = new OleDbConnection(config.ConnectionString))
{
CategoriesTableAdapter tableAdapter;
tableAdapter = new CategoriesTableAdapter();
tableAdapter.Connection = connection;
if (string.IsNullOrEmpty(whereExpression))
recordCount = tableAdapter.Fill(dataset.Categories);
else
recordCount = tableAdapter.FillByWhereClause(dataset.Categories, whereExpression, oleDbParameters);
}
foreach (Category.CategoriesRow row in dataset.Categories.Rows)
{
// use where expression !!
result.Add(new Identity(this.EntityName, row.CategoryID.ToString()));
}
return result;
}
