c# – 使用linq加载除另一个集合之外的集合
发布时间:2020-12-16 00:17:26 所属栏目:百科 来源:网络整理
导读:我有这种搜索方法: public ListEmployeees AutoSuggestEmployeee(string keyword,long employeeeTypeId,int count){ return context.Employeees.Where( x = x.EmployeeeName.Contains(keyword) x.EmployeeeTypeId == employeeeTypeId) .Take(count).ToList(
我有这种搜索方法:
public List<Employeees> AutoSuggestEmployeee(string keyword,long employeeeTypeId,int count) { return context.Employeees.Where( x => x.EmployeeeName.Contains(keyword) && x.EmployeeeTypeId == employeeeTypeId) .Take(count).ToList(); } 我有另一个Employeees集合,比如“BadEmployeees”,我想要的是使用相同的先前方法返回除“BadEmployeees”之外的所有Employeees. 我试着像这样写: return context.Employeees.Where( x => x.EmployeeeName.Contains(keyword) && x.EmployeeeTypeId == employeeeTypeId) .Except(BadEmployeees).Take(count).ToList(); 但它提供了一个例外,即Ex??cept可以使用Int,Guid等数据类型…… 解决方法
如果您很乐意检索所有数据然后执行“除外”,则相对容易:
return context.Employees .Where(x => x.EmployeeName.Contains(keyword) && x.EmployeeTypeId == employeeeTypeId) // Limit the data *somewhat* .Take(count + BadEmployees.Count) // Do the rest of the query in-process .AsEnumerable() .Except(BadEmployees) .Take(count) .ToList(); 或者: // I'm making some assumptions about property names here... var badEmployeeIds = badEmployees.Select(x => x.EmployeeId) .ToList(); return context.Employees .Where(x => x.EmployeeName.Contains(keyword) && x.EmployeeTypeId == employeeeTypeId) && !badEmployeeIds.Contains(x.EmployeeId)) .Take(count) .ToList(); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |