Either new or existing datagrid with form template search as you type is no longer working. Originally thought I had a code issue, but I created a brand new server side application with just one datagrid with form page that included search as you type and same problem.
The page loads fine, but I am unable to search by anything...
Thanks for the help!
I didn't code anything, just created a new application, added a database and ran the template creator. Not sure why it won't work...not giving any error messages
Check your browser console and/or Radzen Output pane.
radzen: Generating code ...
radzen: Code generation done in 227ms.
dotnet: dotnet watch 
Started
dotnet: info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[63]
dotnet: User profile is available. Using 'C:\Users\18022\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
dotnet: info: Microsoft.Hosting.Lifetime[14]
Now listening on: http://localhost:5000
dotnet: info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Development
info: Microsoft.Hosting.Lifetime[0]
Content root path: c:\test\server
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/ - -
dotnet: warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
Failed to determine the https port for redirect.
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_Host'
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[3]
Route matched with {page = "/_Host", action = "", controller = ""}. Executing page /_Host
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[107]
Executing an implicit handler method - ModelState is Valid
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[109]
Executed an implicit handler method, returned result Microsoft.AspNetCore.Mvc.RazorPages.PageResult.
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[4]
Executed page /_Host in 84.0046ms
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/_Host'
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/ - - - 200 - text/html;+charset=utf-8 146.7507ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/Radzen.Blazor.js - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_framework/aspnetcore-browser-refresh.js - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_framework/blazor.server.js - -
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_framework/aspnetcore-browser-refresh.js - - - 200 11966 application/javascript;+charset=utf-8 1.5271ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/assets/css/styles.css - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_framework/blazor.server.js was not modified
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /assets/css/styles.css was not modified
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/Radzen.Blazor.js was not modified
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/assets/css/styles.css - - - 304 - text/css 15.1513ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_framework/blazor.server.js - - - 304 - application/javascript 17.4172ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/Radzen.Blazor.js - - - 304 - application/javascript 17.4457ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/assets/css/styles-generated.css - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /assets/css/styles-generated.css was not modified
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/assets/css/styles-generated.css - - - 304 - text/css 2.1363ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/css/standard.css - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/css/standard.css was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/css/standard.css - - - 304 - text/css 0.3474ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Regular.woff - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/fonts/SourceSansPro-Regular.woff was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Regular.woff - - - 304 - application/font-woff 0.2587ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_blazor/initializers - -
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'Blazor initializers'
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'Blazor initializers'
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_blazor/initializers - - - 200 - application/json;+charset=utf-8 3.4912ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/_blazor/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_blazor/negotiate'
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/_blazor/negotiate'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 POST http://localhost:5000/_blazor/negotiate?negotiateVersion=1 text/plain;charset=UTF-8 0 - 200 316 application/json 8.7088ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_blazor?id=JmAPKmjhG1VLkYbD_-Dt6A - -
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_blazor'
dotnet: info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
Entity Framework Core 6.0.0 initialized 'ConDataContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer:6.0.0' with options: None
dotnet: warn: Microsoft.EntityFrameworkCore.Query[20504]
Compiling a query which loads related collections for more than one collection navigation, either via 'Include' or through projection, but no 'QuerySplittingBehavior' has been configured. By default, Entity Framework will use 'QuerySplittingBehavior.SingleQuery', which can potentially result in slow query performance. See Single vs. Split Queries - EF Core | Microsoft Learn for more information. To identify the query that's triggering this warning call 'ConfigureWarnings(w => w.Throw(RelationalEventId.MultipleCollectionIncludeWarning))'.
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [t].[LeadId], [t].[LeadAccountId], [t].[LeadBdc], [t].[LeadClosed], [t].[LeadContactFname], [t].[LeadContactId], [t].[LeadContactLname], [t].[LeadCreatedBy], [t].[LeadCreatedDate], [t].[LeadCreatedFname], [t].[LeadCreatedLname], [t].[LeadCurrentStep], [t].[LeadMobilePhone], [t].[LeadOwner], [t].[LeadOwnerFname], [t].[LeadOwnerLname], [t].[LeadPrimaryEmail], [t].[LeadPrimarySales], [t].[LeadReviewed], [t].[LeadReviewedBy], [t].[LeadReviewedDate], [t].[LeadSM], [t].[LeadSold], [t].[LeadSoldDate], [t].[LeadSource], [t].[LeadStatus], [t].[LeadStoreId], [t].[LeadTags], [t].[LeadType], [t].[LeadUpdateby], [t].[LeadUpdatedDate], [t].[LeadUpdatedFname], [t].[LeadUpdatedLname], [t].[Accounts], [t].[AccountActive], [t].[AccountName], [t].[ContactId], [t].[AccountId], [t].[City], [t].[ConactActive], [t].[ContactInit], [t].[ContactTags], [t].[CreatedBy], [t].[CreatedDate], [t].[CreatedFname], [t].[CreatedLname], [t].[DateOfBirth], [t].[FirstName], [t].[Gender], [t].[HomePhone], [t].[HomePhoneCC], [t].[HomePhoneDNC], [t].[HomePhonePreferred], [t].[LastName], [t].[MiddleName], [t].[MobilePhone], [t].[MobilePhoneCC], [t].[MobilePhoneDNC], [t].[MobilePhonePreferred], [t].[OpenLead], [t].[Owner], [t].[OwnerFname], [t].[OwnerLname], [t].[PreferredLanguage], [t].[PrimaryEmail], [t].[PrimaryEmailDNE], [t].[PrimaryEmailPreferred], [t].[SecondaryEmail], [t].[SecondaryEmailDNE], [t].[SecondaryEmailPreferred], [t].[State], [t].[StoreId], [t].[Street1], [t].[Street2], [t].[UpdatedDate], [t].[UpdatedFname], [t].[UpdatedLname], [t].[Updatedby], [t].[WorkPhone], [t].[WorkPhoneCC], [t].[WorkPhoneDNC], [t].[WorkPhonePreferred], [t].[ZipCode], [t].[ZipCodePlus4], [c1].[EventId], [c1].[AccountId], [c1].[ApptBadNumber], [c1].[ApptConfirmed], [c1].[ApptLeftMsg], [c1].[ApptNoAnswer], [c1].[EventAppointment], [c1].[EventApptConfirm], [c1].[EventApptNoShow], [c1].[EventApptShow], [c1].[EventCall], [c1].[EventCellCalled], [c1].[EventClosed], [c1].[EventClosedNote], [c1].[EventContactFname], [c1].[EventContactId], [c1].[EventContactLname], [c1].[EventCreatedBy], [c1].[EventCreatedDate], [c1].[EventCreatedFname], [c1].[EventCreatedLname], [c1].[EventCurrentStep], [c1].[EventDateCompleted], [c1].[EventDateDelivered], [c1].[EventDateIn], [c1].[EventDateOut], [c1].[EventDateSold], [c1].[EventEmail], [c1].[EventEmailAddress], [c1].[EventHomeCalled], [c1].[EventHomePhone], [c1].[EventImage], [c1].[EventInShowroom], [c1].[EventLead], [c1].[EventMgrNote], [c1].[EventMobilePhone], [c1].[EventNotes], [c1].[EventOpenNote], [c1].[EventOwner], [c1].[EventOwnerFname], [c1].[EventOwnerLname], [c1].[EventPhoneNo], [c1].[EventPrimaryEmail], [c1].[EventScheduledDate], [c1].[EventShowroom], [c1].[EventSource], [c1].[EventStep1], [c1].[EventStep10], [c1].[EventStep10Active], [c1].[EventStep10Complete], [c1].[EventStep10Delivered], [c1].[EventStep10Sold], [c1].[EventStep1Active], [c1].[EventStep1Complete], [c1].[EventStep1Delivered], [c1].[EventStep1Sold], [c1].[EventStep2], [c1].[EventStep2Active], [c1].[EventStep2Complete], [c1].[EventStep2Delivered], [c1].[EventStep2Sold], [c1].[EventStep3], [c1].[EventStep3Active], [c1].[EventStep3Complete], [c1].[EventStep3Delivered], [c1].[EventStep3Sold], [c1].[EventStep4], [c1].[EventStep4Active], [c1].[EventStep4Complete], [c1].[EventStep4Delivered], [c1].[EventStep4Sold], [c1].[EventStep5], [c1].[EventStep5Active], [c1].[EventStep5Complete], [c1].[EventStep5Delivered], [c1].[EventStep5Sold], [c1].[EventStep6], [c1].[EventStep6Active], [c1].[EventStep6Complete], [c1].[EventStep6Delivered], [c1].[EventStep6Sold], [c1].[EventStep7], [c1].[EventStep7Active], [c1].[EventStep7Complete], [c1].[EventStep7Delivered], [c1].[EventStep7Sold], [c1].[EventStep8], [c1].[EventStep8Active], [c1].[EventStep8Complete], [c1].[EventStep8Delivered], [c1].[EventStep8Sold], [c1].[EventStep9], [c1].[EventStep9Active], [c1].[EventStep9Complete], [c1].[EventStep9Delivered], [c1].[EventStep9Sold], [c1].[EventText], [c1].[EventType], [c1].[EventUpdatedBy], [c1].[EventUpdatedDate], [c1].[EventUpdatedFname], [c1].[EventUpdatedLname], [c1].[EventWebLead], [c1].[EventWorkCalled], [c1].[EventWorkPhone], [c1].[LeadId], [c1].[ManagerReview], [c1].[ManagerReviewDate], [c1].[ManagerReviewFname], [c1].[ManagerReviewLname], [c1].[ManagerReviewedBy], [c1].[StoreId], [c1].[TaskTags], [l].[LeadUnitId], [l].[LeadId], [l].[LeadUnitCategory], [l].[LeadUnitClass], [l].[LeadUnitColor], [l].[LeadUnitCondition], [l].[LeadUnitMSRP], [l].[LeadUnitMake], [l].[LeadUnitMileage], [l].[LeadUnitModel], [l].[LeadUnitModelCode], [l].[LeadUnitNotes], [l].[LeadUnitSalePrice], [l].[LeadUnitStockNo], [l].[LeadUnitTrim], [l].[LeadUnitVin], [l].[LeadUnitYear], [l0].[LeadTradeId], [l0].[LeadId], [l0].[LeadPayoff], [l0].[LeadTradeCategory], [l0].[LeadTradeClass], [l0].[LeadTradeColor], [l0].[LeadTradeMake], [l0].[LeadTradeMileage], [l0].[LeadTradeModel], [l0].[LeadTradeModelCode], [l0].[LeadTradeNotes], [l0].[LeadTradeTrim], [l0].[LeadTradeVin], [l0].[LeadTradeYear]
FROM (
SELECT TOP(1) [c].[LeadId], [c].[LeadAccountId], [c].[LeadBdc], [c].[LeadClosed], [c].[LeadContactFname], [c].[LeadContactId], [c].[LeadContactLname], [c].[LeadCreatedBy], [c].[LeadCreatedDate], [c].[LeadCreatedFname], [c].[LeadCreatedLname], [c].[LeadCurrentStep], [c].[LeadMobilePhone], [c].[LeadOwner], [c].[LeadOwnerFname], [c].[LeadOwnerLname], [c].[LeadPrimaryEmail], [c].[LeadPrimarySales], [c].[LeadReviewed], [c].[LeadReviewedBy], [c].[LeadReviewedDate], [c].[LeadSM], [c].[LeadSold], [c].[LeadSoldDate], [c].[LeadSource], [c].[LeadStatus], [c].[LeadStoreId], [c].[LeadTags], [c].[LeadType], [c].[LeadUpdateby], [c].[LeadUpdatedDate], [c].[LeadUpdatedFname], [c].[LeadUpdatedLname], [a].[Accounts], [a].[AccountActive], [a].[AccountName], [c0].[ContactId], [c0].[AccountId], [c0].[City], [c0].[ConactActive], [c0].[ContactInit], [c0].[ContactTags], [c0].[CreatedBy], [c0].[CreatedDate], [c0].[CreatedFname], [c0].[CreatedLname], [c0].[DateOfBirth], [c0].[FirstName], [c0].[Gender], [c0].[HomePhone], [c0].[HomePhoneCC], [c0].[HomePhoneDNC], [c0].[HomePhonePreferred], [c0].[LastName], [c0].[MiddleName], [c0].[MobilePhone], [c0].[MobilePhoneCC], [c0].[MobilePhoneDNC], [c0].[MobilePhonePreferred], [c0].[OpenLead], [c0].[Owner], [c0].[OwnerFname], [c0].[OwnerLname], [c0].[PreferredLanguage], [c0].[PrimaryEmail], [c0].[PrimaryEmailDNE], [c0].[PrimaryEmailPreferred], [c0].[SecondaryEmail], [c0].[SecondaryEmailDNE], [c0].[SecondaryEmailPreferred], [c0].[State], [c0].[StoreId], [c0].[Street1], [c0].[Street2], [c0].[UpdatedDate], [c0].[UpdatedFname], [c0].[UpdatedLname], [c0].[Updatedby], [c0].[WorkPhone], [c0].[WorkPhoneCC], [c0].[WorkPhoneDNC], [c0].[WorkPhonePreferred], [c0].[ZipCode], [c0].[ZipCodePlus4]
FROM [dbo].[CrmLead] AS [c]
INNER JOIN [dbo].[Accounts] AS [a] ON [c].[LeadAccountId] = [a].[Accounts]
LEFT JOIN [dbo].[Contacts] AS [c0] ON [c].[LeadContactId] = [c0].[ContactId]
) AS [t]
dotnet: LEFT JOIN [dbo].[CrmTasks] AS [c1] ON [t].[LeadId] = [c1].[LeadId]
LEFT JOIN [dbo].[LeadUnitWanted] AS [l] ON [t].[LeadId] = [l].[LeadId]
LEFT JOIN [dbo].[LeadTrades] AS [l0] ON [t].[LeadId] = [l0].[LeadId]
ORDER BY [t].[LeadId], [t].[Accounts], [t].[ContactId], [c1].[EventId], [l].[LeadUnitId]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [dbo].[CrmLead] AS [c]
dotnet: warn: Microsoft.EntityFrameworkCore.Query[10102]
The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased.
dotnet: warn: Microsoft.EntityFrameworkCore.Query[10102]
The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased.
dotnet: warn: Microsoft.EntityFrameworkCore.Query[20504]
Compiling a query which loads related collections for more than one collection navigation, either via 'Include' or through projection, but no 'QuerySplittingBehavior' has been configured. By default, Entity Framework will use 'QuerySplittingBehavior.SingleQuery', which can potentially result in slow query performance. See Single vs. Split Queries - EF Core | Microsoft Learn for more information. To identify the query that's triggering this warning call 'ConfigureWarnings(w => w.Throw(RelationalEventId.MultipleCollectionIncludeWarning))'.
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (37ms) [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[LeadId], [t].[LeadAccountId], [t].[LeadBdc], [t].[LeadClosed], [t].[LeadContactFname], [t].[LeadContactId], [t].[LeadContactLname], [t].[LeadCreatedBy], [t].[LeadCreatedDate], [t].[LeadCreatedFname], [t].[LeadCreatedLname], [t].[LeadCurrentStep], [t].[LeadMobilePhone], [t].[LeadOwner], [t].[LeadOwnerFname], [t].[LeadOwnerLname], [t].[LeadPrimaryEmail], [t].[LeadPrimarySales], [t].[LeadReviewed], [t].[LeadReviewedBy], [t].[LeadReviewedDate], [t].[LeadSM], [t].[LeadSold], [t].[LeadSoldDate], [t].[LeadSource], [t].[LeadStatus], [t].[LeadStoreId], [t].[LeadTags], [t].[LeadType], [t].[LeadUpdateby], [t].[LeadUpdatedDate], [t].[LeadUpdatedFname], [t].[LeadUpdatedLname], [a].[Accounts], [a].[AccountActive], [a].[AccountName], [c0].[ContactId], [c0].[AccountId], [c0].[City], [c0].[ConactActive], [c0].[ContactInit], [c0].[ContactTags], [c0].[CreatedBy], [c0].[CreatedDate], [c0].[CreatedFname], [c0].[CreatedLname], [c0].[DateOfBirth], [c0].[FirstName], [c0].[Gender], [c0].[HomePhone], [c0].[HomePhoneCC], [c0].[HomePhoneDNC], [c0].[HomePhonePreferred], [c0].[LastName], [c0].[MiddleName], [c0].[MobilePhone], [c0].[MobilePhoneCC], [c0].[MobilePhoneDNC], [c0].[MobilePhonePreferred], [c0].[OpenLead], [c0].[Owner], [c0].[OwnerFname], [c0].[OwnerLname], [c0].[PreferredLanguage], [c0].[PrimaryEmail], [c0].[PrimaryEmailDNE], [c0].[PrimaryEmailPreferred], [c0].[SecondaryEmail], [c0].[SecondaryEmailDNE], [c0].[SecondaryEmailPreferred], [c0].[State], [c0].[StoreId], [c0].[Street1], [c0].[Street2], [c0].[UpdatedDate], [c0].[UpdatedFname], [c0].[UpdatedLname], [c0].[Updatedby], [c0].[WorkPhone], [c0].[WorkPhoneCC], [c0].[WorkPhoneDNC], [c0].[WorkPhonePreferred], [c0].[ZipCode], [c0].[ZipCodePlus4], [c1].[EventId], [c1].[AccountId], [c1].[ApptBadNumber], [c1].[ApptConfirmed], [c1].[ApptLeftMsg], [c1].[ApptNoAnswer], [c1].[EventAppointment], [c1].[EventApptConfirm], [c1].[EventApptNoShow], [c1].[EventApptShow], [c1].[EventCall], [c1].[EventCellCalled], [c1].[EventClosed], [c1].[EventClosedNote], [c1].[EventContactFname], [c1].[EventContactId], [c1].[EventContactLname], [c1].[EventCreatedBy], [c1].[EventCreatedDate], [c1].[EventCreatedFname], [c1].[EventCreatedLname], [c1].[EventCurrentStep], [c1].[EventDateCompleted], [c1].[EventDateDelivered], [c1].[EventDateIn], [c1].[EventDateOut], [c1].[EventDateSold], [c1].[EventEmail], [c1].[EventEmailAddress], [c1].[EventHomeCalled], [c1].[EventHomePhone], [c1].[EventImage], [c1].[EventInShowroom], [c1].[EventLead], [c1].[EventMgrNote], [c1].[EventMobilePhone], [c1].[EventNotes], [c1].[EventOpenNote], [c1].[EventOwner], [c1].[EventOwnerFname], [c1].[EventOwnerLname], [c1].[EventPhoneNo], [c1].[EventPrimaryEmail], [c1].[EventScheduledDate], [c1].[EventShowroom], [c1].[EventSource], [c1].[EventStep1], [c1].[EventStep10], [c1].[EventStep10Active], [c1].[EventStep10Complete], [c1].[EventStep10Delivered], [c1].[EventStep10Sold], [c1].[EventStep1Active], [c1].[EventStep1Complete], [c1].[EventStep1Delivered], [c1].[EventStep1Sold], [c1].[EventStep2], [c1].[EventStep2Active], [c1].[EventStep2Complete], [c1].[EventStep2Delivered], [c1].[EventStep2Sold], [c1].[EventStep3], [c1].[EventStep3Active], [c1].[EventStep3Complete], [c1].[EventStep3Delivered], [c1].[EventStep3Sold], [c1].[EventStep4], [c1].[EventStep4Active], [c1].[EventStep4Complete], [c1].[EventStep4Delivered], [c1].[EventStep4Sold], [c1].[EventStep5], [c1].[EventStep5Active], [c1].[EventStep5Complete], [c1].[EventStep5Delivered], [c1].[EventStep5Sold], [c1].[EventStep6], [c1].[EventStep6Active], [c1].[EventStep6Complete], [c1].[EventStep6Delivered], [c1].[EventStep6Sold], [c1].[EventStep7], [c1].[EventStep7Active], [c1].[EventStep7Complete], [c1].[EventStep7Delivered], [c1].[EventStep7Sold], [c1].[EventStep8], [c1].[EventStep8Active], [c1].[EventStep8Complete], [c1].[EventStep8Delivered], [c1].[EventStep8Sold], [c1].[EventStep9], [c1].[EventStep9Active], [c1].[EventStep9Complete], [c1].[EventStep9Delivered], [c1].[EventStep9Sold], [c1].[EventText], [c1].[EventType], [c1].[EventUpdatedBy], [c1].[EventUpdatedDate], [c1].[EventUpdatedFname], [c1].[EventUpdatedLname], [c1].[EventWebLead], [c1].[EventWorkCalled], [c1].[EventWorkPhone], [c1].[LeadId], [c1].[ManagerReview], [c1].[ManagerReviewDate], [c1].[ManagerReviewFname], [c1].[ManagerReviewLname], [c1].[ManagerReviewedBy], [c1].[StoreId], [c1].[TaskTags], [l].[LeadUnitId], [l].[LeadId], [l].[LeadUnitCategory], [l].[LeadUnitClass], [l].[LeadUnitColor], [l].[LeadUnitCondition], [l].[LeadUnitMSRP], [l].[LeadUnitMake], [l].[LeadUnitMileage], [l].[LeadUnitModel], [l].[LeadUnitModelCode], [l].[LeadUnitNotes], [l].[LeadUnitSalePrice], [l].[LeadUnitStockNo], [l].[LeadUnitTrim], [l].[LeadUnitVin], [l].[LeadUnitYear], [l0].[LeadTradeId], [l0].[LeadId], [l0].[LeadPayoff], [l0].[LeadTradeCategory], [l0].[LeadTradeClass], [l0].[LeadTradeColor], [l0].[LeadTradeMake], [l0].[LeadTradeMileage], [l0].[LeadTradeModel], [l0].[LeadTradeModelCode], [l0].[LeadTradeNotes], [l0].[LeadTradeTrim], [l0].[LeadTradeVin], [l0].[LeadTradeYear]
FROM (
SELECT [c].[LeadId], [c].[LeadAccountId], [c].[LeadBdc], [c].[LeadClosed], [c].[LeadContactFname], [c].[LeadContactId], [c].[LeadContactLname], [c].[LeadCreatedBy], [c].[LeadCreatedDate], [c].[LeadCreatedFname], [c].[LeadCreatedLname], [c].[LeadCurrentStep], [c].[LeadMobilePhone], [c].[LeadOwner], [c].[LeadOwnerFname], [c].[LeadOwnerLname], [c].[LeadPrimaryEmail], [c].[LeadPrimarySales], [c].[LeadReviewed], [c].[LeadReviewedBy], [c].[LeadReviewedDate], [c].[LeadSM], [c].[LeadSold], [c].[LeadSoldDate], [c].[LeadSource], [c].[LeadStatus], [c].[LeadStoreId], [c].[LeadTags], [c].[LeadType], [c].[LeadUpdateby], [c].[LeadUpdatedDate], [c].[LeadUpdatedFname], [c].[LeadUpdatedLname]
FROM [dbo].[CrmLead] AS [c]
ORDER BY (SELECT 1)
OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
) AS [t]
INNER JOIN [dbo].[Accounts] AS [a] ON [t].[LeadAccountId] = [a].[Accounts]
LEFT JOIN [dbo].[Contacts] AS [c0] ON [t].[LeadContactId] = [c0].[ContactId]
LEFT JOIN [dbo].[CrmTasks] AS [c1] ON [t].[LeadId] = [c1].[LeadId]
LEFT JOIN [dbo].[LeadUnitWanted] AS [l] ON [t].[LeadId] = [l].[LeadId]
LEFT JOIN [dbo].[LeadTrades] AS [l0] ON [t].[LeadId] = [l0].[LeadId]
ORDER BY [t].[LeadId], [a].[Accounts], [c0].[ContactId], [c1].[EventId], [l].[LeadUnitId]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (20ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [a].[Accounts], [a].[AccountActive], [a].[AccountName]
FROM [dbo].[Accounts] AS [a]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (23ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [c].[ContactId], [c].[AccountId], [c].[City], [c].[ConactActive], [c].[ContactInit], [c].[ContactTags], [c].[CreatedBy], [c].[CreatedDate], [c].[CreatedFname], [c].[CreatedLname], [c].[DateOfBirth], [c].[FirstName], [c].[Gender], [c].[HomePhone], [c].[HomePhoneCC], [c].[HomePhoneDNC], [c].[HomePhonePreferred], [c].[LastName], [c].[MiddleName], [c].[MobilePhone], [c].[MobilePhoneCC], [c].[MobilePhoneDNC], [c].[MobilePhonePreferred], [c].[OpenLead], [c].[Owner], [c].[OwnerFname], [c].[OwnerLname], [c].[PreferredLanguage], [c].[PrimaryEmail], [c].[PrimaryEmailDNE], [c].[PrimaryEmailPreferred], [c].[SecondaryEmail], [c].[SecondaryEmailDNE], [c].[SecondaryEmailPreferred], [c].[State], [c].[StoreId], [c].[Street1], [c].[Street2], [c].[UpdatedDate], [c].[UpdatedFname], [c].[UpdatedLname], [c].[Updatedby], [c].[WorkPhone], [c].[WorkPhoneCC], [c].[WorkPhoneDNC], [c].[WorkPhonePreferred], [c].[ZipCode], [c].[ZipCodePlus4], [a].[Accounts], [a].[AccountActive], [a].[AccountName]
FROM [dbo].[Contacts] AS [c]
INNER JOIN [dbo].[Accounts] AS [a] ON [c].[AccountId] = [a].[Accounts]
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/MaterialIcons-Regular.woff - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/fonts/MaterialIcons-Regular.woff was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/MaterialIcons-Regular.woff - - - 304 - application/font-woff 0.3782ms
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Bold.woff - -
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Semibold.woff - -
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/fonts/SourceSansPro-Bold.woff was not modified
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/fonts/SourceSansPro-Semibold.woff was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Bold.woff - - - 304 - application/font-woff 0.2068ms
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/SourceSansPro-Semibold.woff - - - 304 - application/font-woff 0.1817ms
this is the only warning...
dotnet: warn: Microsoft.EntityFrameworkCore.Query[20504]
Compiling a query which loads related collections for more than one collection navigation, either via 'Include' or through projection, but no 'QuerySplittingBehavior' has been configured. By default, Entity Framework will use 'QuerySplittingBehavior.SingleQuery', which can potentially result in slow query performance. See Single vs. Split Queries - EF Core | Microsoft Learn for more information. To identify the query that's triggering this warning call 'ConfigureWarnings(w => w.Throw(RelationalEventId.MultipleCollectionIncludeWarning))'.
I'm afraid that I don't have any other ideas. Please send us your database/table definition as SQL script at info@radzen.com to try to replicate the issue locally.
