How to implement nested for loop into Linq?

Question

How to convert following nested for loop into linq:

public string MX()
{
    string[] names = { "ali", "reza", "john" };
    string[] roles = { "admin", "user" };
    List<string> result = new List<string>();
    foreach (string username in names)
    {
        foreach (string rolename in roles)
        {
            if (IsUserInRole(username, rolename))
            {
                result.Add(username + " : " + rolename);
            }
        }
    }
    return string.Join("<br>" ,result);
}
public bool IsUserInRole(string username, string rolename)
{
    //code
    return true;
}

score 6 · Answer 1 · edited May 23 '17 at 10:28

6

Check out the related post: How do you perform a CROSS JOIN with LINQ to SQL?.

You could achieve this in the following way:

string result = string.Join("<br>", 
                    from username in names
                    from rolename in roles
                    where IsUserInRole(username, rolename)
                    select username + ":" + rolename);

edited May 23 '17 at 10:28

Community

1
1

answered Dec 21 '13 at 09:39

Igor Ševo

5,339
3
31
73

score 3 · Accepted Answer · edited Dec 21 '13 at 12:31

3

Off the top of my head (not tested):

var result = string.Join("<br>",names.SelectMany(n =>
       roles.Where(r => IsUserInRole(n, r)).Select(r => n + " : " + r))):

edited Dec 21 '13 at 12:31

Samiey Mehdi

8,986
18
48
62

answered Dec 21 '13 at 09:38

Moeri

8,854
5
41
53

How to implement nested for loop into Linq?

2 Answers2