using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class CategoryDB
{
    public static SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
    public static List<Category> getAllCategories()
    {
        List<Category> categories = new List<Category>();
        try
        {
            SqlCommand command = new SqlCommand("Select * from Category");
            command.Connection = connection;
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                categories.Add(new Category(reader["name"].ToString(), reader["description"].ToString()));
            }
            reader.Close();
        }
        finally
        {
            connection.Close();
        }
        return categories;



    }
}