public IEnumerable <Dictionary <string, object> > ExecuteReader(string sql) { var command = _sqlConnection.CreateCommand(); command.CommandText = sql; _setSqlParameters(command); if (_sqlTransaction != null) { command.Transaction = _sqlTransaction; } var reader = command.ExecuteReader(); command.Dispose(); var result = DataReaderConverter.GetList(reader); reader.Close(); SqlParameters = new List <SqlParamWrapper>(); return(result); }