public List GetAllTodos()

in webapi/Models/TodoContext.cs [24:47]


        public List<Todo> GetAllTodos()
        {
            CreateToDosTable();
            List<Todo> list = new List<Todo>();

            using (MySqlConnection conn = GetConnection())
            {
                conn.Open();
                MySqlCommand cmd = new MySqlCommand("select * from ToDos", conn);

                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        list.Add(new Todo()
                        {
                            Status = reader["Status"].ToString(),
                            Task = reader["Task"].ToString()
                        });
                    }
                }
            }
            return list;
        }