I am using ClientObjectModel (C#) to retreive data from a custom list, which is structured like this:
What i need is some kind of "select distinct" which retreives only the categories, without duplicates:
cat1; cat2; cat3;
Im not able to find a way with CAML, and iterating through all items is not an option (the list contains 6000 items, to load each of them is very slow). Is there any other way I dont know?