DataReaderHelper

DataTableHelpers.cs

public static class DataTableHelpers
{
    public static IEnumerable<T> To<T>(this DataTable data)
    {
        Mapper.Initialize(cfg =>
        {
            MapperRegistry.Mappers.Add(new AutoMapper.Data.DataReaderMapper { YieldReturnEnabled = true });
        });

        Mapper.CreateMap<IDataReader, T>();

        return Mapper.Map<IDataReader, IEnumerable<T>>(data.CreateDataReader());
    }

    public static DataTable ToDataTable<T>(this IList<T> data)
    {
        var props = TypeDescriptor.GetProperties(typeof(T));
        var table = new DataTable("DataTable");

        for (var i = 0; i < props.Count; i++)
        {
            var prop = props[i];
            table.Columns.Add(prop.Name, prop.PropertyType);
        }

        var values = new object[props.Count];

        foreach (var item in data)
        {
            for (var i = 0; i < values.Length; i++)
            {
                values[i] = props[i].GetValue(item);
            }
            table.Rows.Add(values);
        }

        return table;
    }
}