Resolve Exception FirstOrDefault could not be translated (Net Core5)

Question

Hello everyone, I took over an old project that was working great that I updated to .net Core 5
I suddenly have this exception when executing my queries. Despite several searches on the subject, I still cannot find any useful solutions. Thanks in advance to anyone who could guide me on a track

Exception: .FirstOrDefault()' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'

//List
    filteredSoldRetailsDtoList = param.sale_product_retails
                                                .Where(x => x.vente.agency.id_enterprise == id_enterprise
                                               && x.sale.date_sale > startDate && x.sale.date_sale < endDate); 

 //Best productSale
                    var BestproductSale= filteredSoldRetailsDtoList 
                        .GroupBy(x => x.product_type_measure.id)
                        .Select(grp => new 
                                                 { number = grp.Key,
                                                   sum = grp.Sum(x => x.quantity * x.p_sale),
                                                   product = grp.FirstOrDefault().product_type_measure })
                        .OrderByDescending(x => x.sum).ToList();

...

Answer 1

This should be an EF Core issue.

Starting with EF Core 3.x, EF no longer evaluates LINQ queries on the client side. You can see this change in the documentation.

Breaking changes included in EF Core 3.x

The easiest way to modify should be to follow the prompts of the exception information, use AsEnumerable() or ToList() to transfer the query to the local instead of the database side.

            //Wrong way  
            var BestproductSale = model.ScoreTables  
                      .GroupBy(x => x.Math)  
                      .Select(grp => new  
                      {  
                          number = grp.Key,  
                          product = grp.ToList().FirstOrDefault().Name  
                      })  
                      .OrderByDescending(x => x.number).ToList();  

            //Right way  
            var BestproductSale = model.ScoreTables.ToList()  
                      .GroupBy(x => x.Math)  
                      .Select(grp => new  
                      {  
                          number = grp.Key,  
                          product = grp.ToList().FirstOrDefault().Name  
                      })  
                      .OrderByDescending(x => x.number).ToList();  

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I don't know your data but perhaps you can something like the following.