public FillByWhereClause ( Product dataTable, string whereClause, System parameters ) : int | ||
dataTable | Product | |
whereClause | string | |
parameters | System | |
Результат | 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; }