如何構造特定的linq查詢？-有解無憂

我有三張桌子，醫生，辦公室和約會。Office 表有一個DoctorId 作為外鍵，Apponitment 有一個外鍵OfficeId。我想在具有相同醫生 ID 的辦公室串列中獲取 OfficeId 等于 Ids 的所有約會。具體來說，我不知道如何從辦公室串列中提取 id。這是我的代碼，為了簡潔我跳過了一些部分：

 public class Appointment1 : BaseEntity
{
    public int? Patient1Id { get; set; }     
    [ForeignKey("Patient1Id")]
    public Patient1 Patient { get; set; } 

    public int Office1Id { get; set; }     
    [ForeignKey("Office1Id")]
    public Office1 Office { get; set; }            
    [DataType(DataType.Date)]
    public DateTime StartDateAndTimeOfAppointment { get; set; }

    [DataType(DataType.Date)]
    public DateTime EndDateAndTimeOfAppointment { get; set; }

    public bool? Status { get; set; }
    public string Remarks { get; set;}       
}
public class Doctor1 : BaseEntity
{
    public int ApplicationUserId { get; set; }     

    [ForeignKey("ApplicationUserId")]
    public ApplicationUser ApplicationUser { get; set; }   
    
    public string Name { get; set; }
    public string Resume { get; set; }
}
public class Office1 : BaseEntity
{
    public int Doctor1Id { get; set; }
    [ForeignKey("Doctor1Id")]
    public Doctor1 Doctor { get; set; }
    
    public decimal InitialExaminationFee { get; set; }
    public decimal FollowUpExaminationFee { get; set; }
    public string Street { get; set; }
    public string City { get; set; }
    public string Country { get; set; }
}

public async Task<List<Appointment1>> GetAppointmentsWithSearchingAndPaging(QueryParameters queryParameters, 
        int userId)
    {
        var doctor = await _context.Doctors1.Where(x => x.ApplicationUserId == userId)
                           .FirstOrDefaultAsync();

        var office = await _context.Offices.Where(x => x.Doctor1Id == doctor.Id)
                     .FirstOrDefaultAsync();

        IQueryable<Appointment1> appointment = _context.Appointments1.Include(x => x.Patient)
                                               .Where(x => x.Office1Id == office.Id)
                                               .AsQueryable().OrderBy(x => x.Id);
        
        if (queryParameters.HasQuery())
        {
            appointment = appointment
            .Where(x => x.Office.Street.Contains(queryParameters.Query));
        }

        appointment = appointment.Skip(queryParameters.PageCount * (queryParameters.Page - 1))
                       .Take(queryParameters.PageCount);
        
        return await appointment.ToListAsync();        
    }

問題在于 office 提供了 firstordefaultasync，并且應該給出串列，因為我想要所有的 id，但最后我只得到具有相同 officeid 作為外鍵的約會......提前感謝！

uj5u.com熱心網友回復：

這是答案，我需要這部分代碼，我的問題不準確所以我道歉：

var office = await _context.Offices.Where(x => x.Doctor1Id == doctor.Id) .ToListAsync();

        IEnumerable<int> ids = offices.Select(x => x.Id);

        IQueryable<Appointment1> appointment = _context.Appointments1.Include(x => x.Patient)
                                               .Where(x => ids.Contains(office.Id))
                                               .AsQueryable().OrderBy(x => x.Id);

轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/318202.html

標籤：C＃林克

上一篇：C#LINQ從串列中選擇，其中值不包含在資料庫中

下一篇：基于在另一個表中查找的更新