public List<sp_getPatientByIdResult> getPatientById(Guid _id)
{
appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
using (objAppointmentDC)
{
var patientById = objAppointmentDC.sp_getPatientById(_id);
return patientById.ToList();
}
}
