public TransactionDto GetTransaction(int transactionId) { var query = string.Format("select id, account, description, currencyCode, amount from TransactionData where id = {0}", transactionId); using (var conn = _connectionProvider.OpenConnection()) { using (var cmd = new SqlCommand(query, conn)) { using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { return(new TransactionDto( id: reader.GetInt32(0), account: reader.GetString(1), description: reader.GetString(2), currencyCode: reader.GetString(3), amount: reader.GetDecimal(4) )); } } } } return(null); }