Hi How do i perform a distinct for a specifc field via Fetchentitycolelction and getdbcount.

The field isnt a primary field rather a foriegn key however the is there a way to pick a specific field to perform a disinct again.

Thanks in advance Gemfore

To fetch one field, you should use a DynamicList (with one field), not an entityCollection. Then on the fetch method, specify false for the allowDuplicate paramater.