Entity Framework - context disposed error

Question

using(ctx e = new ctx())
{
   var pkg = from clPkg in e.PkgCoilPkgs.Include("PkgBand")
                               .Where(c2 => c2.PkgId == PkgID)
                               select new PkgCoilcls
                               {
                                  PkgCoilPkg = clPkg,
                               };
  return pkg.FirstOrDefault();
}

PkgBand is a foreign key table and lazy Loading enabled is set to true

statement: var pkgBand = PkgCoilPkg.PkgBand.Name;

throws

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

Even though I am using Include("PkgBand") to load, Why I am getting this error?

are you sure you have the context instance? check with a brackpoint if e is null or not. — Abdel Raoof Olakara
– Abdel Raoof Olakara, Commented Jan 31, 2011 at 6:22
Thanks, I fixed it using Projection ; select new { PkgCoilPkg, PkgCoilPkg.PkgBand }; Here is more info: stackoverflow.com/questions/4474951/… — mxasim
– mxasim, Commented Jan 31, 2011 at 15:50

Community · Accepted Answer · 2017-05-23 11:47:42Z

1

Thanks, I fixed it using Projection ; select new { PkgCoilPkg, PkgCoilPkg.PkgBand }; Here is more info: Entity Framework Include() is not working

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Apr 15, 2011 at 13:10

mxasim

2,19321 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework - context disposed error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related