I have the entities...

Location LocationID, Name, OrganizationID, <other fields>

Organization OrganizationID, Name

Using the adapter model, how do I execute the query using the IRetrivalQuery interface...

select location.locationid from location where location.organizationid= @organizationID order by location.name

I would like returned from this query some object (DataTable, ...) that I can iterate over to get all the location IDs.

I know that I can grab this data using the normal FetchEntityCollection() functionality, I just dont want to return all the columns I dont need. Is this a candidate for a typed-list?

Thanks for the help, sorry for the simple question.

CT

Yes, you should use a typed list in this instance.

Jeff...