ASP.NET MVC and Entity Framework: query persistance

Question

I'm facing the following problem: in the controller I select the data I need and store it into the ViewData;

using (Models.SkedruleEntities ctx = new Models.SkedruleEntities())
{
    ViewData["users"] = (from u in ctx.User select u);
}

In the View I try to read from the ViewData like this:

<p>
    <%foreach(User user in (IEnumerable<User>)ViewData["users"]) { %>
        <div><%=user.Name %></div>
    <%}%>
</p>

But I get a System.ObjectDisposedException error, as the ViewData seems to contain the query, not the data retrieved by the query and of course the context ctx is no more available.

Any help? Thanks

Thomas Freudenberg · Accepted Answer · 2009-07-03 11:49:45Z

2

You're storing the query in the view data, not the results. So in the view you get the query back and execute it. At that moment the context is already disposed.

The solution is to execute the query in the controller and store the result in the ViewData:

ViewData["users"] = (from u in ctx.User select u).ToList();

answered Jul 3, 2009 at 11:49

Thomas Freudenberg

5,0781 gold badge38 silver badges46 bronze badges

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

Comments

eu-ge-ne · Accepted Answer · 2009-07-03 11:44:02Z

2

Just add ToList():

ViewData["users"] = (from u in ctx.User select u).ToList();

answered Jul 3, 2009 at 11:44

eu-ge-ne

28.2k6 gold badges73 silver badges62 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC and Entity Framework: query persistance

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related