using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        List<Employee> allEmployees = GetAllEmployees();

        // your code goes below ....

    }

    class Employee {

        public long Id { get; set; }

        public long ManagerId { get; set; }

        public List<Employee> DirectReports { get; set; }

    }

    private static List<Employee> GetAllEmployees() {

        var dbContext = new DbContext();

        /*

         * People table

         * =============

         * id long PK auto_increment

         * first_name varchar(50)

         * last_name varchar(50)

         * manager_id long FK references People.id

         */

        return dbContext.Database

                        .SqlQuery<Employee>("SELECT id as Id, manager_id as ManagerId FROM People;")

                        .ToList();

    }

}