public PatientInfo GetPatientInfo(string primId) { var condition = new ParadoxCondition.Compare(ParadoxCompareOperator.Equal, primId, 0, 0); var sr = _Connection.ExecuteQuery("Patients", condition, false); if (sr.Read()) { PatientInfo result = new PatientInfo(); result.PrimID = (string)sr[0]; result.Name = sr[1] == DBNull.Value ? "" : (string)sr[1]; result.Birthdate = sr[2] == DBNull.Value ? "" : (string)sr[2]; result.Sex = sr[3] == DBNull.Value ? "" : (string)sr[3]; result.Physician = sr[4] == DBNull.Value ? "" : (string)sr[4]; result.Diagnosis = sr[5] == DBNull.Value ? "" : (string)sr[5]; return result; } return new PatientInfo { PrimID = primId }; }