如何在Linq中使用IN子句

试试这个代码......

var projIDs= (from ept in _context.ExpiredProjectsTracking
              select ept.id).ToList();

int resultCount= (from apt in _context.AssignedExpiredProjects
                  where projIDs.Contains(apt.ExpiredProjectID)
                  select apt.ExpiredProjectID).Count();