public void Update(Customer model) { using (var connection = new SqlConnection(connectionString)) { var param = new { model.Id, model.Name, model.GenderId, model.HouseNumber, model.AddressLine1, model.State, model.CountryId, model.CategoryId, model.DateOfBirth, model.User }; connection.Execute( AcmeDatabase.StoredProc_CustomerUpdate, param, commandType: CommandType.StoredProcedure); } }
public int Insert(Customer model) { using (var connection = new SqlConnection(connectionString)) { var param = new { model.Name, model.GenderId, model.HouseNumber, model.AddressLine1, model.State, model.CountryId, model.CategoryId, model.DateOfBirth, model.User }; return(connection.Query <int>( AcmeDatabase.StoredProc_CustomerInsert, param, commandType: CommandType.StoredProcedure) .First()); } }