how connect 2 sql server table with a query and use data dynamically : i have two table in sql server
one is member table and other one is friend table
1- in member table we have information of members, like username password etc
2-in friend table, we have userID and FriendID , so we can know each user how many friend have
so with entity framework in asp.net
how i can write a query that i get friends name and ID of  one member?

[tables look like this][1]


[an example of friend table, you can see user with ID =1 have few friend][2]


  [1]: https://i.stack.imgur.com/L7h57.png
  [2]: https://i.stack.imgur.com/aG5s2.png