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