我有两个实体,作业和约会:
public class Job
{
public int JobId { get; set; }
public ICollection<Appointment> Appointments { get; set; }
}
public class Appointment
{
[Key]
public int AppointmentId { get; set; }
[Required]
public DateTime AppointmentDate { get; set; }
[Required]
[MaxLength(50)]
public string Type { get; set; }
public int Job_JobId { get; set; }
[ForeignKey("Job_JobId")]
public virtual Job Job { get; set; }
}如何仅返回具有“初始”约会类型的职务?
如下所示(这不是有效的语法):
jobs = jobs.Where(x => x.Appointments.Where(p => p.Type == "Initial"));发布于 2019-12-30 20:21:50
我相信您正在寻找Any()来引入一个条件,即一个工作必须至少有一个“初始”类型的约会,即:
var initialJobs = jobs
.Where(j => j.Appointments.Any(a => a.Type == "Initial"));Where需要一个谓词参数(返回布尔值的函数),如果至少有一个元素满足内部谓词(a.Type == "Initial"),则Any()返回true
发布于 2019-12-30 20:26:07
如果您只想为类型为Initial的职务装入日程安排,您也可以执行以下操作:
var jobs = appointments.Where(x => x.Type == "Initial").Select(x => x.Job);这将为您提供仅具有初始类型的作业中的约会。
发布于 2019-12-30 20:42:49
如果您希望返回作业列表,只要该列表至少包含一个Type == "Initial",您就应该使用Any(),您的情况看起来如下所示
var jobs = jobs.Where(x => x.Appointments.Any(p => p.Type == "Initial"));或者return job,如果它包含Type == "Initial"的所有约会,则可以使用Where()
var jobs = jobs.Where(x =>
{
var appointmentCount = x.Appointments.Count();
var validAppointments = x.Appointments.Where(p => p.Type == "Initial");
return appointmentCount == validAppointments.Count();
});https://stackoverflow.com/questions/59530673
复制相似问题