Linq query from navigation properties

Question

In entity framework i have two table (two entities): People and Role with one to many relationship. In the People tables i have a navigation property to Role:

public virtual ICollection<Role> Roles { get; set; }

I'm able to retrieve all people that have role as 'barman':

var listPeople = (from p in SiContext.People
                  where p.Roles.Any(x => x.Name == "barman")
                  select p).ToList();

How can i retrieve all people with the related role? I want the person name and surname and the role name (that is in the role table)

Thanks

Hamlet Hakobyan · Accepted Answer · 2014-04-07 20:18:11Z

2

This?

var peoples = SiContext.People.Include("Roles");

or

var peoples = SiContext.People.Include(p => p.Roles);

answered Apr 7, 2014 at 20:18

Hamlet Hakobyan

33.5k6 gold badges55 silver badges71 bronze badges

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

Comments

Gert Arnold · Accepted Answer · 2014-04-07 21:36:31Z

0

You can select from multiple entities:

from p in SiContext.People
from r in p.Roles
select new { Name = p.Name, ..., Role = r.Name }

answered Apr 7, 2014 at 21:36

Gert Arnold

110k36 gold badges219 silver badges319 bronze badges

Collectives™ on Stack Overflow

Linq query from navigation properties

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related