Hi
Thanks for confirming, I have those correct. However I am getting an error when I try to search.
I have created a much simpler sample that kinda works but still having issues with > >> page arrows.
I'll build a simple sample and send it over and would appreciate if you can take a look.
Thanks
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[SectionID], [s].[CategoryForRandomQuestions], [s].[DisplayText], [s].[IncludeSubCatForRandomQuestions], [s].[IsIncluded], [s].[MoodleQuestionID], [s].[NumQuestions], [s].[PaperID], [s].[Pic1], [s].[Pic2], [s].[Pic3], [s].[QuestionCountForRandomQuestions], [s].[SectionBankID], [s].[SectionName], [s].[SectionNumber], [s].[SectionText], [s].[SortOrder], [s].[TagsForRandomQuestions], [p].[PaperID], [p].[BookCoversPath], [p].[BookDocPath], [p].[BookDocTemplatePath], [p].[CourseID], [p].[Description], [p].[DisplayText], [p].[DownloadDocPath], [p].[DownloadDocTemplatePath], [p].[Duration], [p].[ExtraDocPath], [p].[MoodleModuleID], [p].[MoodleQuizID], [p].[MoodleSubQuizID], [p].[Notes], [p].[NumQuestions], [p].[PaperFormatTypeID], [p].[PaperName], [p].[PaperNumber], [p].[PaperTypeID], [s0].[SectionBankID], [s0].[CategoryID], [s0].[DisplayText], [s0].[MoodleQuestionID], [s0].[MoodleQuestionUID], [s0].[Notes], [s0].[Pic1], [s0].[Pic1URL], [s0].[Pic2], [s0].[Pic2URL], [s0].[Pic3], [s0].[Pic3URL], [s0].[SectionName], [s0].[SectionNumber], [s0].[SectionText], [s0].[Tags], [s0].[WPMediaID1], [s0].[WPMediaID2], [s0].[WPMediaID3]
FROM [dbo].[Section] AS [s]
INNER JOIN [dbo].[Paper] AS [p] ON [s].[PaperID] = [p].[PaperID]
LEFT JOIN [dbo].[SectionBank] AS [s0] ON [s].[SectionBankID] = [s0].[SectionBankID]
dotnet: warn: Microsoft.AspNetCore.Components.Server.Circuits.RemoteRenderer[100]
Unhandled exception rendering component: Expression of type 'System.Linq.IQueryable1[System.Object]' cannot be used for parameter of type 'System.Linq.IQueryable
1[SwotBuilder.Models.SwotPaperBuilder.Section]' of method 'System.Linq.IQueryable1[Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier
2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]] Join[Section,Paper,Nullable1,TransparentIdentifier
2](System.Linq.IQueryable1[SwotBuilder.Models.SwotPaperBuilder.Section], System.Collections.Generic.IEnumerable
1[SwotBuilder.Models.SwotPaperBuilder.Paper], System.Linq.Expressions.Expression1[System.Func
2[SwotBuilder.Models.SwotPaperBuilder.Section,System.Nullable1[System.Guid]]], System.Linq.Expressions.Expression
1[System.Func2[SwotBuilder.Models.SwotPaperBuilder.Paper,System.Nullable
1[System.Guid]]], System.Linq.Expressions.Expression1[System.Func
3[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper,Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]]])' (Parameter 'arg0') System.ArgumentException: Expression of type 'System.Linq.IQueryable
1[System.Object]' cannot be used for parameter of type 'System.Linq.IQueryable1[SwotBuilder.Models.SwotPaperBuilder.Section]' of method 'System.Linq.IQueryable
1[Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]] Join[Section,Paper,Nullable
1,TransparentIdentifier2](System.Linq.IQueryable
1[SwotBuilder.Models.SwotPaperBuilder.Section], System.Collections.Generic.IEnumerable1[SwotBuilder.Models.SwotPaperBuilder.Paper], System.Linq.Expressions.Expression
1[System.Func2[SwotBuilder.Models.SwotPaperBuilder.Section,System.Nullable
1[System.Guid]]], System.Linq.Expressions.Expression1[System.Func
2[SwotBuilder.Models.SwotPaperBuilder.Paper,System.Nullable1[System.Guid]]], System.Linq.Expressions.Expression
1[System.Func3[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper,Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier
2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]]])' (Parameter 'arg0')
at System.Dynamic.Utils.ExpressionUtils.ValidateOneArgument(MethodBase method, ExpressionType nodeKind, Expression arguments, ParameterInfo pi, String methodParamName, String argumentParamName, Int32 index)
at System.Linq.Expressions.Expression.Call(MethodInfo method, Expression arg0, Expression arg1, Expression arg2, Expression arg3, Expression arg4)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.ExpandingExpressionVisitor.ExpandNavigation(Expression root, EntityReference entityReference, INavigation navigation, Boolean derivedTypeConversion)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.ExpandIncludesHelper(Expression root, EntityReference entityReference)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.ExpandInclude(Expression root, EntityReference entityReference)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.Visit(Expression expression)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeApplyingExpressionVisitor.Visit(Expression expression)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.ExpandAndReduce(Expression query, Boolean applyInclude)
at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.Expand(Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryTranslationPreprocessor.Process(Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass9_01.<Execute>b__0() at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func
1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func1 compiler) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable
1.GetEnumerator()
at System.Collections.Generic.List1..ctor(IEnumerable
1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Radzen.DataBoundFormComponent
1.get_View()
at Radzen.Blazor.RadzenDropDownDataGrid`1.BuildRenderTree(RenderTreeBuilder __builder)
at Microsoft.AspNetCore.Components.ComponentBase.<.ctor>b__6_0(RenderTreeBuilder builder)
at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.RenderInExistingBatch(RenderQueueEntry renderQueueEntry)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.ProcessRenderQueue()
dotnet: fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
Unhandled exception in circuit 'Ko3sgFR2Od9uElqEitVd1vrASGPzcDa_nik9mjlOebE'.
System.ArgumentException: Expression of type 'System.Linq.IQueryable1[System.Object]' cannot be used for parameter of type 'System.Linq.IQueryable
1[SwotBuilder.Models.SwotPaperBuilder.Section]' of method 'System.Linq.IQueryable1[Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier
2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]] Join[Section,Paper,Nullable1,TransparentIdentifier
2](System.Linq.IQueryable1[SwotBuilder.Models.SwotPaperBuilder.Section], System.Collections.Generic.IEnumerable
1[SwotBuilder.Models.SwotPaperBuilder.Paper], System.Linq.Expressions.Expression1[System.Func
2[SwotBuilder.Models.SwotPaperBuilder.Section,System.Nullable1[System.Guid]]], System.Linq.Expressions.Expression
1[System.Func2[SwotBuilder.Models.SwotPaperBuilder.Paper,System.Nullable
1[System.Guid]]], System.Linq.Expressions.Expression1[System.Func
3[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper,Microsoft.EntityFrameworkCore.Query.TransparentIdentifierFactory+TransparentIdentifier2[SwotBuilder.Models.SwotPaperBuilder.Section,SwotBuilder.Models.SwotPaperBuilder.Paper]]])' (Parameter 'arg0') at System.Dynamic.Utils.ExpressionUtils.ValidateOneArgument(MethodBase method, ExpressionType nodeKind, Expression arguments, ParameterInfo pi, String methodParamName, String argumentParamName, Int32 index) at System.Linq.Expressions.Expression.Call(MethodInfo method, Expression arg0, Expression arg1, Expression arg2, Expression arg3, Expression arg4) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.ExpandingExpressionVisitor.ExpandNavigation(Expression root, EntityReference entityReference, INavigation navigation, Boolean derivedTypeConversion) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.ExpandIncludesHelper(Expression root, EntityReference entityReference) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.ExpandInclude(Expression root, EntityReference entityReference) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeExpandingExpressionVisitor.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.IncludeApplyingExpressionVisitor.Visit(Expression expression) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.ExpandAndReduce(Expression query, Boolean applyInclude) at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.Expand(Expression query) at Microsoft.EntityFrameworkCore.Query.QueryTranslationPreprocessor.Process(Expression query) at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query) at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass9_0
1.b__0()
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func1 compiler) at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func
1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable1.GetEnumerator() at System.Collections.Generic.List
1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 source)
at Radzen.DataBoundFormComponent1.get_View() at Radzen.Blazor.RadzenDropDownDataGrid
1.BuildRenderTree(RenderTreeBuilder __builder)
at Microsoft.AspNetCore.Components.ComponentBase.<.ctor>b__6_0(RenderTreeBuilder builder)
at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.RenderInExistingBatch(RenderQueueEntry renderQueueEntry)
at Microsoft.AspNetCore.Components.RenderTree.Renderer.ProcessRenderQueue()