private void SetAddCommandParameters(SQLiteCommand 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;
}