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

Question

I have this view:

@model MatchGaming.Models.ProfileQuery @{     ViewBag.Title = "Index"; }  <h2>Index</h2>     <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")) {     @Html.ValidationSummary(true)     <fieldset>         <legend>ProfileQuery</legend>         @Html.EditorFor(model=>model.SearchString)         <p>             <input type="submit" value="Create" />         </p>     </fieldset> }  <div>     @Html.ActionLink("Back to List", "Index") </div> 

I have this controller for the HttpPost:

[HttpPost] public ActionResult Results(ProfileQuery profileQuery) {     Debug.Write(profileQuery.SearchString);     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());     } } 

Here is the View for Results:

@model IEnumerable<MatchGaming.Models.UserViewModel>     @{     ViewBag.Title = "Results"; }  <h2>Results</h2>  <fieldset>     <legend>UserViewModel</legend>     @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>     } </fieldset> 

I keep getting this error:

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

I can't figure out why.

Answer 1

I am guessing that the problem is that the execution of your LINQ query has been deferred until starting to access them on your view. At this point db has already been disposed.

Try this:

return View(Users.ToList()); 

Added ToList()

That will force the fetch from the DB before disposing db.