title: Getting a list of users with their assigned role in Identity 2
body: <p>I am stuck trying to get this output</p>
  
  <pre><code>Id | Name   | Role
  ----------------------------
  1  | John   | Administrator
  ----------------------------
  2  | Mary   | Manager
  ----------------------------
  3  | Sage   | Editor
  ----------------------------
  4  | Hank   | Manager
  </code></pre>
  
  <p>I can make it work in LINQPad, but somehow I am unable to translate it to ASP.NET MVC.</p>
  
  <pre><code>from u in Users
  from ur in u.Roles
  join r in Roles on ur.RoleId equals r.Id
  select new {
      Id = u.Id,
      Name = u.Name,
      Role = r.Name,
  }
  </code></pre>
  
  <p>How do I LINQ that in ASP.NET MVC 5 with Identity?</p>
  
  <p>Just to be clear, I am looking for the JOIN query between Users and Roles.</p>