I have a requirement where I need to pull a large collection of strings into memory from the database, which essentially will end up being a List<string>.

I know how to do this using a dynamic list. I can simply create a single ResultsetField, run the query, and then loop over the datatable and create the list.

My question: would using a projection be a more efficient way of achieving this?

Is it possible to project onto a List<string> (I've haven't used projections to date).

Thanks for any insight.

Phil

You should grab the DataProjectorToValueList in the v2.6 beta (runtime sourcecode) and use that class in v2.5 with a projection.

You can see how the projection system work at LLBLGenPro Help files.