title: How to Join two table in Code first approach
body: <p>i have two table, User and Friendship. i want to join this two tables so that the column TheirFriends which have UserID of all friends will have some attribute that is in User. that is i want to get each friend  with all their attribute.
  Output will look like this 
  Theirfriends  firstname LastName UserPicture</p>
  
  <p>i need this linq  and lambda expression.</p>
  
  <p>User:</p>
  
  <pre><code>public class User
  {
  
      public String UserID { get; set; }
      public string FirstName { get; set; }
      public String LastName { get; set; }
  
      public string Description { get; set; }
      public string UserPicture { get; set; }
      public string Gender { get; set; }
      public String Interest { get; set; }
      public DateTime DateOfBirth { get; set; }
      public String Email { get; set; }
  </code></pre>
  
  <p>FriendShip</p>
  
  <pre><code> public class FriendShip
  {
  
      public int FriendShipID { get; set; }
      public string TheirFriends { get; set; }
  
      public String UserID { get; set; }
  }
  </code></pre>