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
– Vivian River, Commented May 8, 2012 at 22:11

Thomas Levesque · Accepted Answer · 2012-05-08 22:36:21Z

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 8, 2012 at 22:36

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vivian River Over a year ago

This sort of works. I'm disappointed to see that I still must manually open and close the connections, tho.

Collectives™ on Stack Overflow

How to get a DbDataReader object directly in Entity Framework?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related