public void AddCustomerList(List<Customer> list)
{
const string sql = @"INSERT INTO Customer
(ID, FirstName, LastName, BirthDay, Height, Weight)
VALUES (@id,@firstName,@lastName,@birthday,@height,@weight)";
var cmd = new FluentCommand<string>(sql)
.AddGuid("id")
.AddString("firstName")
.AddString("lastName")
.AddDateTime("birthday")
.AddDecimal("height")
.AddInt("weight");
foreach (var customer in list)
{
customer.ID = Guid.NewGuid();
cmd.AsNonQuery(customer.ID,
customer.FirstName,
customer.LastName,
customer.Birthday,
customer.Height,
customer.Weight);
}
}
public void FluentExecute()
{
var cmd = new FluentCommand<string>("WithOutParams")
.SetCommandType(CommandType.StoredProcedure)
.Add("out1", 9).SetDirection(ParameterDirection.InputOutput)
.Add("out2", 9).SetDirection(ParameterDirection.InputOutput);
cmd.AsNonQuery();
Console.WriteLine(cmd.GetParamValue("out1"));
Console.WriteLine(cmd.GetParamValue("out2"));
}
public void FluentCommandKeepAliveWithTransaction()
{
var conn = ConnectionFactory.GetConnection();
using (var trans = conn.BeginTransaction())
{
using (FluentCommand<int> cmd = new FluentCommand<int>(_sql, conn))
{
cmd.SetTransaction(trans)
.AddInt("id")
.AddString("code", 15)
.AddString("name", 255)
.AddString("mft", 56)
.AddString("size")
.AddBoolean("discontinued")
.AddString("barcode", 56);
for (int i = 0; i < _productList.Count; i++)
{
var product = _productList[i];
cmd.AsNonQuery(
product.ID, product.ProductCode, product.Name, product.Manufacturer, product.Size,
!product.Active, product.ProductCode);
}
}
trans.Commit();
}
}
public void FluentCommandKeepAlive()
{
using (FluentCommand<int> cmd = new FluentCommand<int>(_sql))
{
cmd.AddInt("id")
.AddString("code", 15)
.AddString("name", 255)
.AddString("mft", 56)
.AddString("size")
.AddBoolean("discontinued")
.AddString("barcode", 56);
for (int i = 0; i < _productList.Count; i++)
{
var product = _productList[i];
cmd.AsNonQuery(
product.ID, product.ProductCode, product.Name, product.Manufacturer, product.Size,
!product.Active, product.ProductCode
);
}
}
}
