public void UpdateTaskStatus(long taskID, StatusType status) { int statusValue = (int)status; StringBuilder sb = new StringBuilder(); sb.Append("UPDATE Task SET StatusValue = "); sb.Append(statusValue.ToString()); sb.Append(" WHERE ID = "); sb.Append(taskID.ToString()); using (IDbConnection connection = _provider.CreateConnection()) { connection.Open(); _provider.ExecuteNonQuery(connection, sb.ToString(), CommandType.Text); } }