entity framework - ObjectDisposedException when getting foreign key field -

i created model using db context generator, using ef 4. model this:

program table: id name

group table: id name programid (associated program.id)

i want display these columns in grid:

program.name - group.name

but grdgroups.datasource = db.groups.tolist()

doesn't return program.name

when try objectdisposedexception.

partial public class group      public readonly property programname() string                       return program.name          end     end property end class 

what's best way return program.name include in grid datasource?

when try objectdisposedexception

the problem lazy loading - ef did not materialize related program entity, hence when try access program.name try , re-query db, context has been disposed @ point, exception.

you can use include() query when retrieve group entity, specify want load related program entity, i.e. :

var groups = context.groups.include(x => x.program);