Entity Framework query using navigation properties

Question

Users have many Roles. Roles have many Privileges. I need to get a list of privileges assigned to user based on roles user may have. I have something like this in mind but it gives me an IEnumerable of IEnumerable of Privilege:

List<Privilege> privileges = user.Roles.Select(r=>r.Privileges.Where(p=>p.IsActive));

How can I do this using navigation properties?

Michael Christensen · Accepted Answer · 2012-08-14 03:55:32Z

2

SelectMany

It flattens the ienumerables as you go

answered Aug 14, 2012 at 3:55

Michael Christensen

1,7861 gold badge13 silver badges11 bronze badges

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

Comments

Bishnu Paudel · Accepted Answer · 2012-08-14 04:18:50Z

1

Try this:

user.Roles.SelectMany(r => r.Privileges).Where(p=>p.IsActive).ToList();

answered Aug 14, 2012 at 4:18

Bishnu Paudel

2,0891 gold badge22 silver badges39 bronze badges

Collectives™ on Stack Overflow

Entity Framework query using 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