public List<sp_SearchPrescriptionsByPatientNameResult> getPrescriptionsByPatientName(string patientName) { List<sp_SearchPrescriptionsByPatientNameResult> myList = new List<sp_SearchPrescriptionsByPatientNameResult>(); try { prescriptionsDataContext obj = new prescriptionsDataContext(); myList = obj.sp_SearchPrescriptionsByPatientName(patientName).ToList(); } catch (Exception ex) { clsCommon.saveError(ex); } return myList; }