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;
}