AllProductsContainingString.AllProductsContainingStringUI.GetProductsContainingString C# (CSharp) Method

        static IEnumerable<string> GetProductsContainingString(string searched, SqlConnection dbConnection)
        {
            searched = searched.Replace("%", "[%]");
            searched = searched.Replace("_", "[_]");

            dbConnection.Open();
            using (dbConnection)
            {
                IList<string> productsContainingString = new List<string>();

                SqlCommand productsContainingStringCommand = new SqlCommand(
                    @"SELECT ProductName FROM Products
                      WHERE ProductName LIKE @searched",
                    dbConnection);
                productsContainingStringCommand.Parameters.AddWithValue("@searched", string.Format("%{0}%", searched));

                SqlDataReader productsInfo = productsContainingStringCommand.ExecuteReader();
                using (productsInfo)
                {
                    while (productsInfo.Read())
                    {
                        productsContainingString.Add((string)productsInfo["ProductName"]);
                    }
                }

                return productsContainingString;
            }
        }
    }