asp.net mvc 4 - mvc4 How to extract value from a tolist query in controller -

asp.net mvc 4 - mvc4 How to extract value from a tolist query in controller -

ok basic setup; user logins unique id of user myid, seek list of logged in user friends going friends table shown in variable myfriends notice have selected friendid column represents uniqueid of friend. compare myid profileid should match if they're friends. problem using .tolist() on myfriends variable , can't seem extract friendid (i using tolist() because user can have more 1 friend tolist counts amount of records) compare in friendprofile variable because .tolist() gives value of how many records extracted. how can friendid value myfriends can compare in friendprofile can show users friends profile ? help great

[authorize] public actionresult myprofile() { // logged in user unique id int myid = convert.toint32(user.identity.name); // list of logged in user friends id var myfriends = sqlconnection.query<friend>("select friendid friends myid=@profileid",new { profileid = myid }).tolist(); // friends profiles var friendprofile = sqlconnection.query<profile>("select * profiles friendid=@profile",new { profile = myfriends }).tolist(); }

you can single query using sql in operator

int myid = convert.toint32(user.identity.name); var friendprofile = sqlconnection.query<profile>("select * profiles friendid in (select friendid friends myid=@profile)",new { profile = myid }).tolist();

asp.net-mvc-4 model-view-controller actionresult