public List<sp_getAppByPatientIDResult> getAppByPatientID(Guid pid) //added by REshma { AppointmentsDataContext obj = new AppointmentsDataContext(); return obj.sp_getAppByPatientID(pid).ToList(); }