Can this be converted to a Lamba Expression?
var getCategory = cd.tbl_Category.ToList();
var getCategoryCheck = cd.tbl_CategoryCheck.Where(x => x.User_Id == userId).ToList();
list.Add(new ReportDTO
{
Category = "Cat Main",
SubCategory = "Cat Main 2",
ROneCount = (from r in getCategory
from o in getCategoryCheck
where r.CategoryId == o.CategoryId
where r.Category == "1"
select r.CategoryId).Count(),
}
...
Go to the complete details ...