A helper class to read SQL results into a dynamic object

DynamicSqlDataReader.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;

public class DynamicSqlDataReader
{
	private static dynamic ToExpando(IDataRecord record)
	{
		var expandoObject = new ExpandoObject() as IDictionary<string, object>;

		for (var i = 0; i < record.FieldCount; i++)
			expandoObject.Add(record.GetName(i), record[i]);

		return expandoObject;
	}

	public IEnumerable<dynamic> Read(SqlDataReader reader)
	{
		while (reader.Read())
		{
			yield return ToExpando(reader);
		}
	}
}