LINQ-can';t使用WHERE条件创建
本文关键字:WHERE 条件 创建 使用 LINQ-can | 更新日期: 2023-09-27 18:26:39
我有以下方法:
public DataTable.DataTablesPage<DataTable.UserModel> DataTableUserListByAttendees(int geoArea, int CurrentUserID)
{
var result = from i in _dbContext.Users
where i.GeographicalAreas.Any(p => p.GeoAreaID == geoArea)
select new DataTable.UserModel()
{
ID = i.ID,
Company = i.Company,
DCMember = (i.UserId != null),
FirstName = i.FirstName,
LastName = i.LastName
};
}
它工作正常,但它返回没有设置geoArea proeprty的实体。
public DataTable.DataTablesPage<DataTable.UserModel> DataTableUserListByAttendees(int? geoArea, int CurrentUserID)
{
var result = from i in _dbContext.Users
where i.GeographicalAreas.Any(p => p.GeoAreaID == geoArea)
select new DataTable.UserModel()
{
ID = i.ID,
Company = i.Company,
DCMember = (i.UserId != null),
FirstName = i.FirstName,
LastName = i.LastName
};
}
我如何更改查询,使其只返回设置了geoArea属性的实体(也就是不为null)。
where (geoArea == null) || i.GeographicalAreas.Any(p => p.GeoAreaID == geoArea)
或者有条件地将where添加到查询
应该是
where geoArea == null || i.GeographicalAreas.Any(p => p.GeoAreaID == (int)geoArea)