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

.net asp.net-mvc-3 c# entity-framework exception-handling

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.

1
40
12/18/2011 2:33:30 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

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.

51
3/19/2011 6:15:26 AM

Popular Answer

Your using clause is disposing of (read: destroying) the MatchGamingEntities db context before the View has a chance to use it. So while you can just enumerate the items before (or as) you pass the Users to the View, a better approach is to drop your use of the using clause and let natural garbage collection do its work after you truly done with it--which won't be until after the View is done.

For more information, see this question on the Entity Framework and Connection Pooling.

witttness

Related Questions

Am I crazy for using Entity Framework with an OleDB connection?

The approach you are using to build the EF connection string is correct....BUT......The Entity Framework only works with Providers (i.e. SqlClient) that support something called provider services....The OleDB provider doesn't support 'Provider Services' so you can't use EF with the OleDb (unless you can find a third party OleDb provider with suppor...
c# entity-framework ms-access
asked by Alex James

While binding, the ObjectContext object was disposed of.

This is my code:...public class JobsRepository:BaseNewsletterRepository { public IEnumerable<Job> GetJobs() { var jobs = Newsletterctx.Jobs.Include("Info").OrderBy(o => o.JobID); return jobs.AsEnumerable(); } } public class BusinessNewsletter { public static IEnumerable<Job> GetJobs() { usi...
.net c# entity-framework exception-handling
asked by shlomjmi

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

This is because of Using statement. When your function finishes execution, it disposes object context. When the result IQueryable is enumerated, it tries to use disposed object, so you get the Exception. Remove using, let your sevice implement IDisposable and dispose your object context in IDisposable.Dispose()
c# entity-framework exception-handling wcf wcf-data-services
asked by archil

How can I prevent getting the message "The ObjectContext object has been discarded and cannot be utilized for activities that need a connection"?

If you look at the method public T008_SESSIONS Insert(icarus_portalEntities entities)...you are passing a reference of your entities object and because it is using a using statement ...using (entities) {} ...it will dispose the object
asp.net c# entity-framework
asked by TBohnen.jnr

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

To just add to Sergey's point,...Instead of this,...RSPDbContext db = new RSPDbContext(); var brands = db.KBrands.Include(b => b.Company).ToList(); // assign brands to listbox ...This worked for me.....RSPDbContext db = new RSPDbContext(); var brands = db.KBrands.Include("Company").ToList(); // assign brands to listbox
c# entity-framework wpf
asked by sriharsha KB

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

By default Entity Framework uses lazy-loading for navigation properties. That's why these properties should be marked as virtual - EF creates proxy class for your entity and overrides navigation properties to allow lazy-loading. E.g. if you have this entity:...public class MemberLoan { public string LoandProviderCode { get; set; } public virt...
asp.net c# entity-framework
asked by Sergey Berezovskiy

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

You should include them in your original query. You can do this using ...Include...:...List<Item> items; using (var context = new YourContext()) { items = context.Items.Include(x => x.Messages).ToList(); }
.net c# database entity-framework
asked by Kristof Claes

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

By default Entity Framework uses lazy-loading for navigation properties. That's why these properties should be marked as virtual - EF creates proxy class for your entity and overrides navigation properties to allow lazy-loading. E.g. if you have this entity:...public class MemberLoan { public string LoandProviderCode { get; set; } public virt...
asp.net c# entity-framework
asked by Sergey Berezovskiy

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

You have lazy loading enabled. So when you try to load reference property there is no way to do it, because ObjectContext disposed right after ...using... block....There are two ways to fix it:...//1. Tell EF to load Country property immediately. using(var db = new jQGridEntities()) { customers = db.Customers.Include(c => c.Country).ToList(); }...
asp.net asp.net-mvc-4 c# entity-framework sql
asked by lorond

The ObjectContext instance has been disposed and can no longer be used

I had the same problem and solved like below;...I created a new object and put the values I am gonna use after getting object from db....Example Code:... var listFromDb= db.XTable.Where(x => x.Id > 5).ToList(); var list = new List<Package>(); foreach (var item in listFromDb) { var a = new Package() { AccountNo = item.Accoun...
asp.net-mvc c# dispose entity-framework
asked by Project Mayhem

How can I fix "The ObjectContext instance has been disposed "

I developed an application with entity framework. I get the ...The ObjectContext instance has been disposed and can no longer be used for operations that require a connection....error from sometimes....I did some research on the internet but I couldn't figure it out. I would be very grateful if you could help...HomeController:...public ActionResu...
asp.net asp.net-mvc-4 entity entity-framework entity-framework-6
asked by Engin Ozsozgun

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

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