Use filters to retrieve data for collection

public EntityCollection GetPagesByAppId(int AppId)
{
RelationPredicateBucket filter = new RelationPredicateBucket(PageFields.AppId == AppId);

EntityCollection pages = new EntityCollection();
using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(pages, filter);
return pages;
}

}