LINQ IQueryable with List;输入参数

Question

如果我输入一个字符串作为参数，以下函数效果很好，但我想为其提供一个字符串列表，即不是为其提供一个项目的名称，例如“AccountTracker”，我可以为它提供多个项目名称，即“AccountTracker”、“GameX”、“HR1”。如何转换 LINQ 查询来执行此操作？

存在以下关系 Employee(1--)EmployeeProjects(--1)Project

[WebGet]
public IQueryable<Employee> GetEmployeesByProjects(string project)
{
   var employees = from ep in CurrentDataSource.EmployeeProjects
          .Include("Project")
          .Include("Employee")
       where ep.Project.ProjectName == project
       select ep.Employee;
   return employees;
}

Answer 1

将项目作为字符串列表发送，您可以使用如下的 Contains 方法

[WebGet]
public IQueryable<Employee> GetEmployeesByProjects(List<string> projects)
{
   var employees = from ep in CurrentDataSource.EmployeeProjects
          .Include("Project")
          .Include("Employee")
       where projects.Contains(ep.Project.ProjectName)
       select ep.Employee;
   return employees;
}

，也可以将项目作为 "AccountTracker,GameX,HR1" 发送一个字符串

[WebGet]
public IQueryable<Employee> GetEmployeesByProjects(string listofprojects)
{
   string[] projects= listofprojects.Split(',');
   var employees = from ep in CurrentDataSource.EmployeeProjects
          .Include("Project")
          .Include("Employee")
       where projects.Contains(ep.Project.ProjectName)
       select ep.Employee;
   return employees;
}