title: SQL to LINQ Conversion in C#
body: <p>Can anybody tell the equivalent LINQ syntax for this query in c#?</p>
  
  <pre><code>SELECT     Users.UserName, UserStatus.StatusTitle, UserStatus.StatusDetails
  FROM UserStatus 
  INNER JOIN  Users ON UserStatus.UserId = Users.UserID
  where Users.userid=3 
  OR users.userID in (
   SELECT     UserFriends.FriendId
   FROM Users 
   INNER JOIN UserFriends ON Users.UserID = UserFriends.UserId
   where Users.userid=3 )
  </code></pre>