Project_Marmelade.Business.OptimizationBusiness.OptimPersist.GetProductInfo C# (CSharp) Method

        public List<string> GetProductInfo()
        {
            List<string> dbProductNames = new List<string>();
            try
            {
                SqlCommand cmd = new SqlCommand("spGetProductNames", conn);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.HasRows && rdr.Read())
                {
                    dbProductNames.Add((string)rdr["RecipeName"]);
                }
            }
            catch (SqlException e)
            {
                string s = e.Message;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }

            return dbProductNames;
        }
    }

        public List<string> GetProductNames()
        {
            OptimPersist db = new OptimPersist();
            List<string> prodList = db.GetProductInfo();

            return prodList;
        }