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 ); } } }