I need to optimize a query to return only the PK's from a table.

GetMulti(null) against my table returns all the data in the table. I only need the PK column. I cant seem to find a way to do this via the documentation.

Am I going about this the wrong way?

Thanks, Alex

You can project a PK resulset on a EntityCollection. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=11776

I am using v2.0. Is this feature available?

Yes that is in 2.0. Also, if you go to 2.5, you can have it only bring back certain fields in the getmulti call...

Projection is available since v. 2.0. And in v. 2.5 you may execlude fields from being fetched (a new feature). Which also enables you to fetch the excluded fields later on into the same collection.

Otherwise you may just use a DynamicList, wich IMHO is the best solution, especially if there is no need for the EntityCollection.

oh right DynamicList, thats ringing some bells.

Thanks Guys!!!