title: Show first role for each Identity user in view
body: <p>In a controller returning a list of all Identity users I wish to be able to find a users role (have only 1 per user), and include that in the view being able to show "Role" as a column next to the user in the view. </p>
  
  <p>Tried different types of lambda expressions, but unfortunately without luck.</p>
  
  <p>"ApplicationUser" is a new model class adding a couple of new fields to IdentityUser table.</p>
  
  <p>I have set a filter on UserName, and the code works for this specific table.</p>
  
  <p>Here is my action so far:</p>
  
  <pre><code>public async Task&lt;IActionResult&gt; Index()
  {
  return View(await _db.ApplicationUser.Where(u =&gt; u.UserName != "-").ToListAsync());
  }
  </code></pre>
  
  <p>I have tried to experiment with the "Include" expression, but it doesn't work for me.</p>
  
  <p>Wonder if I need a ViewModel for this purpose, or a lambda expression can do it for me?</p>
  
  <p>I expect to be able to show a table in a view showing fx. username, phone number and role name for each user</p>