score:0

Accepted answer
        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);

 

Related Query