public List<sp_SearchPrescriptionDetailsResult> getPrescriptionDetails(int prescriptionId) { List<sp_SearchPrescriptionDetailsResult> myList = new List<sp_SearchPrescriptionDetailsResult>(); try { prescriptionsDataContext obj = new prescriptionsDataContext(); myList = obj.sp_SearchPrescriptionDetails(prescriptionId).ToList(); } catch (Exception ex) { clsCommon.saveError(ex); } return myList; }