title: Getting all users and their roles (membership and roles) with Linq2Sql, right query?
body: <p>I am trying to get all users and their roles from the generated membership and roles tables, and I came up with this:</p>
  
  <pre><code>var query = from a in aspnet_Users
              select new { a.UserName, a.UserId } into b
              join c in aspnet_UsersInRoles on b.UserId equals c.UserId
              join d in aspnet_Roles on c.RoleId equals d.RoleId
              group d.RoleName by b;
  </code></pre>
  
  <p>Is this good or is there a better way to do this?</p>