title: EntityDataSource - how to do WHERE Clause from different table
body: <p>Hi I am using EF 4 and EntityDataSource in a Page (WebForms).</p>
  
  <p>This page contains a DropDownList that display UserName.
  Data from this DropDownList it is from "aspnet_Users".
  At the moment I am using a single EntityDataSource code belove:</p>
  
  <pre><code>                &lt;asp:EntityDataSource ID="EntityDataSourceListUsers" runat="server" ConnectionString="name=CmsConnectionStringEntityDataModel"
                  DefaultContainerName="CmsConnectionStringEntityDataModel" EnableFlattening="False"
                  EntitySetName="aspnet_Users" Select="it.[UserId], it.[UserName]"&gt;
              &lt;/asp:EntityDataSource&gt;
  </code></pre>
  
  <p><strong>I need to FILTER the UserName associated to a specific ROLE</strong> and displaying it in the DropDownList therefore using others tables
  "aspnet_UsersInRoles" and "aspnet_Roles".</p>
  
  <p>How to do it?</p>
  
  <p>Thanks guys for your time.</p>