public List <MessageDTO> GetAllBySender(int id) { List <MessageDTO> messages = new List <MessageDTO>(); try { string sql = "SELECT * FROM Message WHERE SenderId = @SenderId "; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("SenderId", id.ToString()), }; DataSet Results = ExecuteSql(sql, parameters); for (int x = 0; x < Results.Tables[0].Rows.Count; x++) { MessageDTO dto = DataSetParser.DataSetToMessage(Results, x); messages.Add(dto); } return(messages); } catch (Exception e) { throw e; } }