any improvement in following linqtosql query where i shouldn't need select if possible

21 Views Asked by At

following is my query

 return await (from ofr in _context.table1
                          join aca in _context.table2
                          on new { a = ofr.f1, b = ofr.f2}
                         equals new { a = (int?)aca.f1, b = aca.f2}
                          where lstStatusesTocheck.Contains(ofr.status)
                          select new { ofr.id }
                          ).CountAsync();

can i avoid select new { ofr.id } and directly get the count somehow

0

There are 0 best solutions below