Filter joined string array

Question

I have a linq query that returns all users with their identity roles. I am able to filter the results by using where claused however, I am unable to figure out how to filter based on a role name. Below is my linq query. var userList = (from user in _context.Users orderby user.UserName select new UserForDetailDto { Id = user.Id, UserName = user.UserName, Email = user.Email, Roles = (from userRole in user.UserRoles join role in _context.Roles on userRole.RoleId equals role.Id select role.Name). ToArray() }).AsQueryable(); The below is sample of what is returned. [ { "id": 6, "userName": "Adam", "email": "johndoe@test.com.au", "roles": [ " Supplier ", "Assistant Buyer" ] }, { "id": 1, "userName": "Admin", "email": "janedoe@test.com.au", "roles": [ "Administrator" ] } ] I am able to filter the userList using a where clause such as the one below. userList = userList.Where(u => u.UserName.ToLower().Contains(userParams.UserName.ToLower())); I would like to be able to add a where clause to the role.Name string array. Where roles contains 'Supplier' for example. Any help would be appreciated.

Michael Seery · Answer

Using the && condition would only return the filtered role and not all roles associated with the user that has the filtered role. Solution What I did was use the GetUsersInRolesAsync to get a list of the users with the selected role, then filtered the original list of users with their roles by this list using the following where clause. userList = userList.Where(u => filterNames.Contains(u.UserName.ToLower())); if (! string .IsNullOrEmpty(userParams.Roles)) { var filteredUserList = await _userManager.GetUsersInRoleAsync(userParams.Roles); List string > filterNames = new List string >(); foreach (var filtUser in filteredUserList) { filterNames.Add(filtUser.UserName.ToLower()); } userList = userList.Where(u => filterNames.Contains(u.UserName.ToLower())); } var userList = (from user in _context.Users orderby user.UserName select new UserForDetailDto { Id = user.Id, UserName = user.UserName, LockedOut = user.LockedOut, SupplierId = user.SupplierId, WarehouseId = user.WarehouseId, Email = user.Email, Status = user.Status, Roles = (from userRole in user.UserRoles join role in _context.Roles on userRole.RoleId equals role.Id select role.Name).ToArray() }).AsQueryable();

Sagar Malde · Answer

Hi Michael, you can use var User = userList.Where(x=> x.Roles.Where(z=> z == "Supplier" ).Count() > 0).ToList();

Jignesh Kumar · Answer

Hi, You can try below code, you can use && condition in your where clause.

Michael Seery · Answer

Hi Ravi, I am using asp.net core identity. I have a linq query that returns a list of all users with their associated role names in a string array. Each user may have more than one role. I am currently able to filter the returned list by by all fields accept for the associated roles. If you look at the sample data below. I have a user with multiple roles and one that doesn't have any role associated with them. [ { "id": 6, "userName": "Adam", "email": "johndoe@test.com.au", "roles": [ " Supplier ", "Assistant Buyer" ] }, { "id": 1, "userName": "Admin", "email": "janedoe@test.com.au", "roles": [ "Administrator" ] }, { "id": 5, "userName": "Jane", "email": "janedoe@test.com.au", "roles": [] } ] If I filter using the role as example 'Supplier' I would like to see the following returned. [ { "id": 6, "userName": "Adam", "email": "johndoe@test.com.au", "roles": [ " Supplier ", "Assistant Buyer" ] } ] 2 points to note. 1. Both roles are listed for the user with a role of supplier. 2. The user with no roles associated with them is not returned. Thanks again for your help.

Ravi Patel · Answer

Hi Michael Seery, c an you please tell me what is your requirement?

Michael Seery · Answer

Thanks so much for the quick reply. It appears to be working however it also returns user that have not been assigned a role. { "id": 5, "userName": "jane", "email": "janedoe@test.com.au", "roles": [ ] } Also it doesn't return all of the roles associated with a user if they have more than the selected role. For example user Adam has 2 roles. { "id": 6, "userName": "Adam", "email": "johndoe@test.com.au", "roles": [ "Supplier", "Assistant Buyer" ] } When I filter for supplier I get back the roles minus the Assistant Buyer role. (Please take no notice of the role names, these are just samples) { "id": 6, "userName": "Adam", "email": "johndoe@test.com.au", "roles": [ "Supplier" ] }

Ravi Patel · Answer

Hi, try this var userList = (from user in _context.Users orderby user.UserName select new UserForDetailDto { Id = user.Id, UserName = user.UserName, Email = user.Email, Roles = (from userRole in user.UserRoles join role in _context.Roles on userRole.RoleId equals role.Id where role.Name == "Admin" select role.Name).ToArray() }).AsQueryable();