예제 #1
0
        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);
        }