public async Task <IList <Comment> > GetTransactionComments(ESRTransaction transaction) { string cmd = $@"SELECT CreatedBy, CreatedOn, CommentText, TransactionID, BatchID FROM Comments WHERE TransactionID = '{transaction.ID}' ORDER BY CreatedOn ASC;"; return(await GetComments(cmd)); }