CategoriesNamesAndDescriptions.CategoriesNamesAndDescriptionsUI.GetCategoriesInfo C# (CSharp) Метод

        static IEnumerable<string> GetCategoriesInfo(SqlConnection dbConnection)
        {
            IList<string> categoriesInfo = new List<string>();
            dbConnection.Open();
            using (dbConnection)
            {
                SqlCommand getCategoriesInfoQuery = new SqlCommand(
                    "SELECT CategoryName, Description FROM Categories", dbConnection);

                SqlDataReader dbInfo = getCategoriesInfoQuery.ExecuteReader();
                using (dbInfo)
                {
                    StringBuilder categoryInfo = new StringBuilder();
                    while (dbInfo.Read())
                    {
                        categoryInfo.AppendFormat(
                            "Name: {0} | Description: {1}",
                            (string)dbInfo["CategoryName"],
                            (string)dbInfo["Description"]);
                        categoriesInfo.Add(categoryInfo.ToString());
                        categoryInfo.Clear();
                    }
                }
            }

            return categoriesInfo;
        }
    }