LINQ select property from object in query

Question

I have a list of recipients to send a message, but I want to exclude those from a certain Role, the problem is that I have this:

var recipients = (from up in _db.UserProfiles
                  join ms in _db.MembershipEntities
                      on up.UserId equals ms.UserId
                  join st in _db.Studios
                      on up.StudioId equals st.StudioId
                  select new
                  {
                      up.UserId,
                      up.UserName,
                      up.StudioId,
                      st.Name,
                      ms.Roles
                  }).ToList();

And the result is what I want, only that the query returns an object Role which has a RoleID and a RoleName, so Im not sure how to select the RoleName so I can specify which role I want to exclude.

Could you give us a small sample set (input, output, wanted output, why)? — It'sNotALie.
– It'sNotALie., Commented Nov 27, 2013 at 18:04
Do you want to only return users from the database if they have a given role or would you rather return all users to memory and then filter based on a given role? — Smudge202
– Smudge202, Commented Nov 27, 2013 at 18:07

Henk Mollema · Accepted Answer · 2013-11-27 18:12:16Z

1

You could add a where clause to the query which filters the users within a certain role:

where ms.Roles.All(role => role.RoleName != "<insert role name>")

Your complete query will look like this:

(from up in _db.UserProfiles
    join ms in _db.MembershipEntities on up.UserId equals ms.UserId
    where ms.Roles.All(role => role.RoleName != "<insert role name>")
    join st in _db.Studios on up.StudioId equals st.StudioId
    select new { up.UserId, up.UserName, up.StudioId, st.Name, ms.Roles})
    .ToList();

answered Nov 27, 2013 at 18:12

Henk Mollema

46.9k12 gold badges101 silver badges107 bronze badges

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

Collectives™ on Stack Overflow

LINQ select property from object in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related