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

    public static class Class1
    {
        public static IEnumerable<IDictionary<String, Object>> ReadStuff(this SqlConnection connection)
        {
            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 static 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;
        }
    }
}