does LLBLGen support "Select Distinct"? If so, what is the syntex?

Thanks

select distinct is used with TypedLists and Projections. I cannot be used with Entities (not sure about EntityViews).

with adapter you call DataAccessAdapter.FetchTypedList(...); using the overloads you can specifiy allowDuplicates. False = Distinct, True = Dups.

The Self Servicing syntax would be similar, but I don't know the exact function name.

For entities: distinct is emitted when necessary / possible when fetching entities. So, you don't have to worry about that, you never get duplicates back.