Hi,

If I have the following code...

adapter.FetchTypedList(fields, dynamicList, bucket, 10000, sortExpression, true);

What does the 10000 or max number of items to return do? The generated SQL doesn't have a 'TOP 10000' in it.

Cheers, I.

Try only returning distinct rows. I see the top only if I do not allow duplicates.

top is only emitted in a scenario with relations if distinct is also emitted. Distinct is only emitted if you tell the query to do that, i.e. as Brian says: to set allowDuplicates to false.

If you don't want to specify a limit, you don't have to specify a high number, just specify 0.