1400/02/05 |

query

سلام و عرض ادب

من این کؤری را دارم

var proposals = _context.Proposals
                .Include(p => p.ProposalInSubjects).ThenInclude(p1 => p1.Subject)
                .Include(p => p.Student)
                .Include(p => p.TeacherInProposals).ThenInclude(p1 => p1.Teacher)
                .AsQueryable();

 

این شرط را گداشتم ولی کار نمیکنه

 

var prop = proposals.Select(p2 => new ResultGetProposalDto
                {
                    Subject = p2.Subject,
                    PLink = p2.PLink,
                    ID = p2.ID,
                    InsertTime = p2.InsertTime,
                    StID = p2.StudentID,
                    Student = p2.Student,

                    Subjects = p2.ProposalInSubjects.Select(p3 => new ProposalInSubject
                    {

                        SubjectID = p3.SubjectID,
                        Subject = p3.Subject
                    }).ToList(),

                    TeacherInProposals = p2.TeacherInProposals.Select(p3 => new TeacherInProposal
                    {
                        TeacherID = p3.TeacherID,
                        Status = p3.Status,
                        Teacher = p3.Teacher,
                        ID = p3.ID,

                    }).Where(p4 => p4.Status == request.Status).ToList(),

 

                }).ToList();

همیشه همه رکوردها را نشون میده در صورتی که میخام روی status در جدول    TeacherInProposals فیلتر کنه