private void SaveProduct(Product product)
{
new FluentCommand<Product>(_sql)
.AddInt("id", product.ID)
.AddString("code", product.ProductCode)
.AddString("name", product.Name)
.AddString("mft", product.Manufacturer)
.AddString("size", product.Size)
.AddBoolean("discontinued", !product.Active)
.AddString("barcode", product.BarCode)
.AsNonQuery();
}
private void SetAddCommandParameters(SqlCommand cmd, Product product)
{
cmd.Parameters[0].Value = product.ID;
cmd.Parameters[1].Value = product.ProductCode;
cmd.Parameters[2].Value = product.Name;
cmd.Parameters[3].Value = product.Manufacturer;
cmd.Parameters[4].Value = product.Size;
cmd.Parameters[5].Value = !product.Active;
cmd.Parameters[6].Value = product.BarCode;
}
private List<Product> CreateProductList()
{
const int ProductCount = 2000;
var list = new List<Product>(ProductCount);
for (int i = 0; i < ProductCount; i++)
{
var cust = new Product { ID = i, Name = "TestProduct", Active = true, Manufacturer = "TestMfg", BarCode = i.ToString(), ProductCode = i.ToString(), Size = "Cup" };
list.Add(cust);
}
return list;
}