score:3

Accepted answer
return (from a in ObjectContext.tblaptmts
        join ch in ObjectContext.tblConsultationHours 
             on  a.consultationID equals ch.consultationID
        where  a.studentID == StuId
        select new StudentViewAppointment() 
                  {                       
                       AppointmentId = a.aptmtID,
                       Apremark = a.apremark,
                       -----
                       -----
                  });

Related Articles