DataReader AsEnumerable (LINQ) with fields name

drenumerable.cs

// create a static class
public static class DataReaderExtension
{
    public static IEnumerable<Dictionary<string, object>> AsEnumerable(this System.Data.IDataReader source)
    {
        if (source == null)
            throw new ArgumentNullException("source");

        while (source.Read())
        {
            Dictionary<string, object> row = new Dictionary<string, object>();
            for (int i = 0; i < source.FieldCount; i++)
            {
                object value = source.GetValue(i);
		// return an empty string for dbnull value of field type string
                if (source.GetFieldType(i) == typeof(string) && source.IsDBNull(i))
                    value = string.Empty;
                row.Add(source.GetName(i), value);
            }
            yield return row;
        }
    }
}

// suppose you have a class named MYBooks with properties names ID (int) and TITLE (string)
// and the datareader contains more records with two fileds named ID_BOOK and TITLE

myDataReader.AsEnumerable().Select(i => new MYBooks()
{
	ID = (int)i["ID_BOOK"],
	TITLE = (string)i["TITLE"]
});