How to get a DbDataReader object directly in Entity Framework?

Question

According to MSDN (http://msdn.microsoft.com/en-us/library/dd487208.aspx), there is an object called DbDataReader that is created in the process of running a SQL query in Entity Framework.

Entity Framework "translates" the DbDataReader into a entity class.

How can I access the DbDataReader directly?

I was hoping that there is some way to access the values returned from SQL directly while still having the benefit of having EF manage connections and all the rest. — Vivian River, May 08 '12 at 22:11

score 1 · Accepted Answer · answered May 08 '12 at 22:36

1

You can access the data reader it if you execute the query yourself:

using (var command = context.Connection.CreateCommand())
{
    command.CommandText = "SELECT ...3;
    using (var reader = command.ExecuteReader())
    {
        ...
    }
}

answered May 08 '12 at 22:36

Thomas Levesque

286,951
70
623
758

This sort of works. I'm disappointed to see that I still must manually open and close the connections, tho. – Vivian River May 09 '12 at 16:43

How to get a DbDataReader object directly in Entity Framework?

1 Answers1