public void Delete(ServiceTicket ticket) { using (var connection = new SqlConnection(DbHelper.GetDatabaseConnectionString(_databaseName))) { connection.Open(); connection.Execute("delete from ServiceTickets where ID = @ID", ticket); connection.Close(); } }
public void Update(ServiceTicket ticket) { var props = typeof(ServiceTicket).GetProperties() .Where(p => !string.Equals(p.Name, "id", StringComparison.InvariantCultureIgnoreCase)).ToList(); var setter = string.Join(", ", props.Select(p => $"{p.Name}=@{p.Name}")); var query = $"Update ServiceTickets set {setter} where ID = @ID"; using (var connection = new SqlConnection(DbHelper.GetDatabaseConnectionString(_databaseName))) { connection.Open(); connection.Execute(query, ticket); connection.Close(); } }