stuffreader.cs

namespace SqlStuff
{
    using System.Data.SqlClient;
    using System;
    using System.Collections.Generic;

    public class Class1: IDisposable
    {
        private readonly SqlConnection connection = new SqlConnection("Data Source=garai;Initial Catalog=testChina;Integrated Security=True");

        public Class1()
        {
            connection.Open();
        }

        public IEnumerable<IDictionary<String, Object>> ReadStuff()
        {
            string query = "SELECT * FROM dbo.test";

            using (var command = new SqlCommand(query, connection))
            using (SqlDataReader reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    yield return ReadAsDictionary(reader);
                }
            }
        }

        private IDictionary<String, Object> ReadAsDictionary(SqlDataReader reader)
        {
            IDictionary<String, Object> dataRecord = new Dictionary<String, Object>();

            for (var i = 0; i < reader.FieldCount; i++)
            {
                dataRecord.Add(reader.GetName(i), reader.GetValue(i));
            }

            return dataRecord;
        }

        public void Dispose()
        {
            connection?.Dispose();
        }
    }
}