如何编写LINQ查询以与值列表进行比较?

var result=(from e in DataContext.Employee
           where CompanyListIds.Contains(e.CompanyId)).ToList();

如果在数据库中设置了正确的键,并且在实体关系图中配置了导航属性,则应该能够执行以下操作:

var result = DataContext.Companies.SelectMany(c => c.Employees);

但如果没有,您可以简单地使用Contains:

var result = DataContext.Employee
                        .Where(e => CompanyListIds.Contains(e.CompanyId));

var result= DataContext.Employee.Where(e=> CompanyListIds.Contains(e.CompanyId)).ToList();