RadzenDropDownDataGrid cast exception

Radzen.Blazor Components
1

Hello,
I'm trying to use RadzenDropDownDataGrid (instead of RadzenDropDown) in order to load a huge amount of data. RadzenDropDownDataGrid seems to be the right component because it includes pagination and search filters.
Actually we are getting this huge amount of data from MongoDb using the AsQueryable driver Linq extension.
But unfortunately we receive this exception because the component try to use something like a cast function that is not supported from the driver.

How to solve that? Why this component doesn't work as the similar RadzenDatagrid or RadzenDropDown in terms of data retrieving? RadzenDatagrid works very well with the AsQueryable driver Linq extension.

warn: Microsoft.AspNetCore.Components.Server.Circuits.RemoteRenderer[100]
      Unhandled exception rendering component: Expression not supported: identifiers.identifiers.Aggregate([]).Cast().
      MongoDB.Driver.Linq.ExpressionNotSupportedException: Expression not supported: identifiers.identifiers.Aggregate([]).Cast().
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToPipelineTranslators.ExpressionToPipelineTranslator.Translate(TranslationContext context, Expression expression)
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToExecutableQueryTranslators.CountMethodToExecutableQueryTranslator.Translate[TDocument](MongoQueryProvider`1 provider, TranslationContext context, MethodCallExpression expression)
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToExecutableQueryTranslators.ExpressionToExecutableQueryTranslator.TranslateScalar[TDocument,TResult](MongoQueryProvider`1 provider, Expression expression, ExpressionTranslationOptions translationOptions)
         at MongoDB.Driver.Linq.Linq3Implementation.MongoQueryProvider`1.Execute[TResult](Expression expression)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.OnLoadData(LoadDataArgs args)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.OnDataChanged()
         at Radzen.DataBoundFormComponent`1.SetParametersAsync(ParameterView parameters)
         at Radzen.DropDownBase`1.SetParametersAsync(ParameterView parameters)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.SetParametersAsync(ParameterView parameters)
fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
      Unhandled exception in circuit 'tHS9_VhyTSHxf9tXZAM7OkSdT1xverHWi6VgBV8TrRU'.
      MongoDB.Driver.Linq.ExpressionNotSupportedException: Expression not supported: identifiers.identifiers.Aggregate([]).Cast().
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToPipelineTranslators.ExpressionToPipelineTranslator.Translate(TranslationContext context, Expression expression)
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToExecutableQueryTranslators.CountMethodToExecutableQueryTranslator.Translate[TDocument](MongoQueryProvider`1 provider, TranslationContext context, MethodCallExpression expression)
         at MongoDB.Driver.Linq.Linq3Implementation.Translators.ExpressionToExecutableQueryTranslators.ExpressionToExecutableQueryTranslator.TranslateScalar[TDocument,TResult](MongoQueryProvider`1 provider, Expression expression, ExpressionTranslationOptions translationOptions)
         at MongoDB.Driver.Linq.Linq3Implementation.MongoQueryProvider`1.Execute[TResult](Expression expression)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.OnLoadData(LoadDataArgs args)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.OnDataChanged()
         at Radzen.DataBoundFormComponent`1.SetParametersAsync(ParameterView parameters)
         at Radzen.DropDownBase`1.SetParametersAsync(ParameterView parameters)
         at Radzen.Blazor.RadzenDropDownDataGrid`1.SetParametersAsync(ParameterView parameters)

where identifiers is a IEnumerable assigned using AsQueryable extension

<RadzenDropDownDataGrid TValue="IdentifierSheet"
                        FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive"
                        FilterOperator="StringFilterOperator.StartsWith"
                        Data="@identifiers"
                        PageSize="10">
    <Columns>
        <RadzenDropDownDataGridColumn Property="@nameof(IdentifierSheet.Symbol)"
                                      Title="@nameof(IdentifierSheet.Symbol)"
                                      Width="150px" />
        <RadzenDropDownDataGridColumn Property="@nameof(IdentifierSheet.Identifier)"
                                      Title="@nameof(IdentifierSheet.Identifier)"
                                      Width="200px" />
        <RadzenDropDownDataGridColumn Property="@nameof(IdentifierSheet.Exchange)"
                                      Title="@nameof(IdentifierSheet.Exchange)"
                                      Width="150px" />
        <RadzenDropDownDataGridColumn Property="@nameof(IdentifierSheet.SecurityType)"
                                      Title="@nameof(IdentifierSheet.SecurityType)"
                                      Width="150px" />
    </Columns>
</RadzenDropDownDataGrid>

Thank you

2

The same can be achieved with DropDown component using virtualization. No matter which component you will choose try to handle LoadData and perform desired/supported query operations if the default IQueryable support doesn’t work for you.