title: Entity Framework and include
body: <p>I have created a edmx model of the aspnet login account holders tables. </p>
  
  <p>Entityframework removes the AspNetUserRoles table and display a relationship directly between AspNetRole and the AspNetUser tables</p>
  
  <p>The question I have is how or what is the best why to get a list of AspNetUser in a certain role role?</p>
  
  <pre><code>Public Function getAccountHoldersInRoles(role As String) As IEnumerable(Of AspNetUser)
  
      Dim aspNetUsers = From u In db.AspNetUsers.Include("AspNetRoles")
  
      For Each u In aspNetUsers
  
             ??????????????
  
      Next
  
  
      Return aspNetUsers
  End Function
  </code></pre>