public static IEnumerable <Service> GetServices(string serviceName = "%") { var reader = InventoryDb.GetServices(name: serviceName).CreateDataReader(); while (reader.Read()) { var sId = int.Parse(reader["Service_ID"].ToString()); var sName = reader["ProductName"].ToString(); yield return(new Service(sId, sName)); } reader.Close(); }