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

Question

I am using Entity Framework with a business Later, DAL and a base Interface. I am inheriting the IDispose interface in my repository, I am getting the following error trying to get this list back. most of the examples I have come across suggest using IEnumerable and add .ToList() for the query and I have already as seen below. How can I get around this? This is working in other places where I have similar multiple related entity queries, I dont understand why im getting the error here? If someone can point out with an example in code how to fix this that would be great.

public IEnumerable<Orders> GetOrdersByCustomer(int customer_id)
{
    IEnumerable<Orders> ordersList = context.Employees
        .Include("Orders")
        .Include("Customers")
        .Where(c => c.Customers.customer_id == customer_id)
        .ToList();

    return ordersList;
}

Daniel Imms · Accepted Answer · 2013-02-03 09:45:29Z

3

I found the reason it wasnt working actually I had to do something like

public IEnumerable<Orders> GetOrdersByCustomer(int customer_id)
{              
    IEnumerable<Orders> ordersList = context.Employees
        .Include("Customers")
        .Include("Customers.Orders")
        .Where(c => c.Customers.customer_id == customer_id)
        .ToList();          
    return ordersList;
}

edited Feb 3, 2013 at 9:45

Daniel Imms

50.6k19 gold badges157 silver badges170 bronze badges

answered Sep 14, 2011 at 13:29

Shokwave

831 silver badge7 bronze badges

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

2 Comments

PeterX Over a year ago

Thanks - it seems as long as you include what you need to reference, you don't get the error.

TehOne Over a year ago

Yep, the trick is to make sure you don't access anything that wasn't included, after the context gets disposed.

Erik Philips · Accepted Answer · 2011-09-08 21:53:57Z

1

It sounds like whatever class you have which "owns" the context has disposed of it, and a subsequent call in the line IEnumerable<Orders> ordersList = context.Employees.Include is throwing an error.

answered Sep 8, 2011 at 21:53

Erik Philips

54.9k11 gold badges133 silver badges158 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related