avoid multiple db calls sql server : i have a list of n records and for each record id i need to fetch a list of  integers( partids ) from db..
currently from the app i am having to loop n times passing the main id to fetch each list from db.
Obv this is affecting the performance of the app.(dot net win app using vb.net)
Is there any way that i can avoid multiple calls?
like can i send a list of ids n get my desired result as output?
example 
input : record1 having id 100

output:
id 100 ,partid 1,2,3

same for n rows
dont know how..any help please