public static Medicine GetMedicineByName(string medicineName) { var query = SqlQueryGeneration.GetMedicineByName(medicineName); return(FillObjectData(query).FirstOrDefault()); }