Convert SqlDataReader to linq expression

Question

When looking at examples on the internet on how to use SqlDataReader I found things like:

var command = new SqlCommand(  // initialize with query and connection...
var reader = command.ExecuteReader();

while(reader.Read())
{
    var foo = reader["SomeColName"];
    // etc
}

Can I use the following extension method:

public static IEnumerable<IDataReader> ToEnumerable(this IDataReader reader)
{
     while (reader.Read())            
         yield return reader;            
}  

In order to execute queries using linq?

If I use the following extension method will it be bad? If I care about performance should I use the first implementation?

Answer 1

You just need to cast your IEnumerable to IEnumerable<IDataRecord>

var enumerable = reader.Cast<IDataRecord>();
var col = enumerable.Select(record => record .GetOrdinal("SomeColName"));