| public FillByWhereClause ( Product dataTable, string whereClause, System parameters ) : int | ||
| dataTable | Product | |
| whereClause | string | |
| parameters | System | |
| return | int | |
/* Get */
public override List <Identity> GetAll(NorthwindConfig config, string whereExpression, OleDbParameter[] oleDbParameters)
{
List <Identity> result = new List <Identity>();
int recordCount = 0;
DataSets.Product productsDataset = new DataSets.Product();
// get the first 11 rows of the changelog
using (OleDbConnection connection = new OleDbConnection(config.ConnectionString))
{
DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter;
tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter();
tableAdapter.Connection = connection;
if (string.IsNullOrEmpty(whereExpression))
{
recordCount = tableAdapter.Fill(productsDataset.Products);
}
else
{
recordCount = tableAdapter.FillByWhereClause(productsDataset.Products, whereExpression, oleDbParameters);
}
}
foreach (DataSets.Product.ProductsRow row in productsDataset.Products.Rows)
{
// use where expression !!
result.Add(new Identity(this.EntityName, row.ProductID.ToString()));
}
return(result);
}
/* Get */
public override List<Identity> GetAll(NorthwindConfig config, string whereExpression, OleDbParameter[] oleDbParameters)
{
List<Identity> result = new List<Identity>();
int recordCount = 0;
DataSets.Product productsDataset = new DataSets.Product();
// get the first 11 rows of the changelog
using (OleDbConnection connection = new OleDbConnection(config.ConnectionString))
{
DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter;
tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter();
tableAdapter.Connection = connection;
if (string.IsNullOrEmpty(whereExpression))
recordCount = tableAdapter.Fill(productsDataset.Products);
else
recordCount = tableAdapter.FillByWhereClause(productsDataset.Products, whereExpression, oleDbParameters);
}
foreach (DataSets.Product.ProductsRow row in productsDataset.Products.Rows)
{
// use where expression !!
result.Add(new Identity(this.EntityName, row.ProductID.ToString()));
}
return result;
}