The ObjectContext object has been deleted and cannot be utilized for any activities that require a connection.

.net c# entity-framework exception-handling


I think as follows:

@model MatchGaming.Models.ProfileQuery
    ViewBag.Title = "Index";

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

@using (Html.BeginForm("Results", "Profiles")) {
            <input type="submit" value="Create" />

    @Html.ActionLink("Back to List", "Index")

I have the following HttpPost controller:

public ActionResult Results(ProfileQuery profileQuery)
    using(var db = new MatchGamingEntities())
        var SearchUserName = db.Users.SingleOrDefault(a=> a.UserName.Contains(profileQuery.SearchString));
        var Users = from m in db.Users
                    join m2 in db.MyProfiles on m.UserId equals m2.UserId
                    where m.UserName == SearchUserName.UserName
                    select new UserViewModel
                        UserName = m.UserName,
                        LastActivityDate = m.LastActivityDate,
                        Address = m2.Address,
                        City = m2.City,
                        State = m2.State,
                        Zip = m2.Zip

        return View(Users.AsEnumerable());

The View for Results is shown below:

@model IEnumerable<MatchGaming.Models.UserViewModel>    
    ViewBag.Title = "Results";


    @foreach (var item in Model){
    <div class="display-label">UserName</div>
    <div class="display-field">@item.UserName</div>

    <div class="display-label">LastActivityDate</div>
    <div class="display-field">@String.Format("{0:g}", item.LastActivityDate)</div>

    <div class="display-label">Address</div>
    <div class="display-field">@item.Address</div>

    <div class="display-label">City</div>
    <div class="display-field">@item.City</div>

    <div class="display-label">State</div>
    <div class="display-field">@item.State</div>

    <div class="display-label">Zip</div>
    <div class="display-field">@item.Zip</div>

This error keeps occurring:

The ObjectContext instance has been disposed and can no longer be used for operations that require a connection.

I'm stumped as to why.

12/18/2011 2:33:30 PM

Accepted Answer

My best bet is that the issue is that your LINQ query's execution has been delayed until you begin accessing them on your view. In this momentdb has already been thrown away.

Do this:

return View(Users.ToList());

Put On List ()

By doing so, the retrieve from the DB will be forced before disposal.db .

3/19/2011 6:15:26 AM

Popular Answer

The MatchGamingEntities database context is being destroyed by your using clause before the View can utilize it. A better strategy is to abandon your usage of the using clause and allow natural garbage collection do its job when you actually done with it, which won't be until after the View is done. This is because you can simply enumerate the items before (or as) you pass the Users to the View.

See this inquiry on Connection Pooling and the Entity Framework for further details.

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow