Entity framework linq include

Question

I have the following Linq query I'm working with entity framework.

var res = from a in _db.Articles
                  from auth in a.Authors
                  where papers.Contains(a.JoomlaId)
                  select auth.Institution;

The problem is that my institution class has a variable named "Type" of type "InstitutionType" that I need to include, and I have no idea how to do that.

Don't call your variable "type", your future self will kill you — Sayse
– Sayse, Commented Jun 24, 2013 at 22:08
You do have a point, i don't deny it but if i call it InstitutionType, it will be like Institution.InstitutionType which doesn't seam ok either. — Bobby Tables
– Bobby Tables, Commented Jun 24, 2013 at 22:15
AssociatedType? I would try programmers exchange, institutiontype sounds good to me though, it doesnt sound like a static type — Sayse
– Sayse, Commented Jun 24, 2013 at 22:21

Maciej · Accepted Answer · 2013-06-24 22:58:35Z

10

var res = from a in _db.Articles.Include("Authors") 
                                .Include("Authors.Institution")
                                .Include("Authors.Institution.Type")
                  from auth in a.Authors
                  where papers.Contains(a.JoomlaId)
                  select auth.Institution;

edited Jun 24, 2013 at 22:58

answered Jun 24, 2013 at 22:09

Maciej

2,1851 gold badge18 silver badges29 bronze badges

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

1 Comment

Bobby Tables Over a year ago

Should have been

var res = from a in _db.Articles 							.Include("Authors") 							.Include("Authors.Institution") 							.Include("Authors.Institution.Type") 					  from auth in a.Authors 					  where papers.Contains(a.JoomlaId) 					  select auth.Institution;

Can u please edit so i can mark it as an answer

Collectives™ on Stack Overflow

Entity framework linq include

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related