Retrieving unique (distinct) values from a dataset to populate a dropdown

I need to retrieve unique values ​​from an invoke to populate a dropdown in Radzen ANGULAR . I know I can filter and sort but not sure where to provide the Distinct () clause to produce the correct query

Hi @Pro,

Check the customization help article. You should use a partial class and method e.g.

public partial class CategoriesController
{
    partial void OnCategoriesRead(ref IQueryable<Category> items)
    {
        items = items.Distinct();
    }
}