public void DeleteCustomer(Customer customer) { const string sql = "DELETE FROM Customer WHERE ID = @id"; new FluentCommand<Customer>(sql) .AddGuid("id", customer.ID) .AsNonQuery(); }
public void AddCustomer(Customer customer) { customer.ID = Guid.NewGuid(); const string sql = @"INSERT INTO Customer (ID, FirstName, LastName, BirthDay, Height, Weight) VALUES (@id,@firstName,@lastName,@birthday,@height,@weight)"; new FluentCommand<string>(sql) .AddGuid("id", customer.ID) .AddString("firstName", customer.FirstName) .AddString("lastName", customer.LastName) .AddDateTime("birthday", customer.Birthday) .AddDecimal("height", customer.Height) .AddInt("weight", customer.Weight) .AsNonQuery(); }