ef core 3 linq query

[azizkazdal]

Below code works fine at ef core 2.2 bu not working on ef core 3

 var items = (from asset in Context.Assets
                         join assetCategory in Context.AssetCategories on asset.CategoryId equals assetCategory.Id
                         group assetCategory by assetCategory.Id into assetCategories
                         select new AssetCategorySummary
                         {
                             CategoryId = assetCategories.Key,
                             CategoryName = assetCategories.Select(p => p.CategoryName).FirstOrDefault(),
                             TotalAsset = assetCategories.Count()
                         }).ToListAsync();

the error I am getting

Processing of the LINQ expression 'AsQueryable<string>(Select<AssetCategory, string>(
    source: NavigationTreeExpression
        Value: default(IGrouping<Guid, AssetCategory>)
        Expression: (Unhandled parameter: e), 
    selector: (p) => p.CategoryName))' by 'NavigationExpandingExpressionVisitor' 
failed. This may indicate either a bug or a limitation in EF Core. 
See https://go.microsoft.com/fwlink/?linkid=2101433 for more detailed information.

[smitpatel]

Grouping.Select.FirstOrDefault is being tracked by #13805