title: how would I write linq query that would display user name instead of userID in a gridview
body: <p>how would I write linq query that would display user name instead of userID in a gridview.</p>
  
  <pre><code>var q = from u in entities.problems
                         join a in entities.my_aspnet_membership on u.user_id equals a.userId
                         join c in entities.my_aspnet_users on a.userId equals c.id
                         where c.id == a.userId
                         select new { u.problem_id, c.name, u.problem_description, u.problem_reported_datetime, u.problem_history}; 
  </code></pre>
  
  <p>What I am looking is when uasing login in the webiste only to see problems they submitted.</p>