c# - Efficiently requesting multiple entities -

i need request lists of different entities without relation (in order create relation). example:

var attributegroups = db.attribute_group.where(g => attributegroupids.contains(g.id)); var attributes = db.attribute.where(g => attributeids.contains(g.id)); 

when iterate results later, make multiple database calls? there way make 1?

your option calling stored procedure return multiple resultsets. see http://romiller.com/2012/08/15/code-first-stored-procedures-with-multiple-results/