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, Jan 31 '11 at 06:22
Thanks, I fixed it using Projection ; select new { PkgCoilPkg, PkgCoilPkg.PkgBand }; Here is more info: http://stackoverflow.com/questions/4474951/entity-framework-include-is-not-working — mxasim, Jan 31 '11 at 15:50

score 1 · Accepted Answer · edited May 23 '17 at 11:47

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 '17 at 11:47

Community

1
1

answered Apr 15 '11 at 13:10

mxasim

2,153
21
15

Entity Framework - context disposed error

1 Answers1