public static IEnumerable <Item> GetSuppliedItems(string supplierId = "%", string itemName = "%") { var reader = InventoryDb.GetSupplierItems(supplierId, itemName).CreateDataReader(); while (reader.Read()) { var pId = int.Parse(reader["Item_ID"].ToString()); var pName = reader["ProductName"].ToString(); var pStock = int.Parse(reader["Stock"].ToString()); var pPrice = decimal.Parse(reader["Price"].ToString()); yield return(new Item(pId, pName, pStock, pPrice)); } }